Re: $$Excel-Macros$$ I love excel because.......

hello friends, In my opinion " Excel is In built end-user automated application which saves lot of valuable time by proper utilization of excel addin's and formulas... Regards, Raj On Fri, Aug 27, 2010 at 11:49 PM, Ayush wrote: > Its a very handy tool for any data analysis and rep

Re: $$Excel-Macros$$ Hi all

Learn from Help menu in excel On Sat, Aug 28, 2010 at 11:05 AM, Pankaj Kumar wrote: > Hi, All, > > > I am fresher in ms excel & wanted to learned how to prepared Pivot table & > report in Msexcel > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e-mail: rajputpanka...@gmail.com >

$$Excel-Macros$$ Excel

Hi, All, I am fresher in ms excel & wanted to learn about basic and advance excel. Can someone please help me in this. Regards., Niesh 9930704827 -- -- Some important links for excel users: 1. Follow us on TWIT

$$Excel-Macros$$ I love excel because.......

Its a very handy tool for any data analysis and reporting. - Ayush Jain --- Guyzzz, Let me know why you like excel so muchThe best response will be published on the home page with thanks. Pl

Re: $$Excel-Macros$$ Hi all

Table Complited Go to data cleck privot table select range finist On Sat, Aug 28, 2010 at 11:05 AM, Pankaj Kumar wrote: > Hi, All, > > > I am fresher in ms excel & wanted to learned how to prepared Pivot table & > report in Msexcel > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e

Re: $$Excel-Macros$$ Give a Solution

THANKS A TON On Fri, Aug 27, 2010 at 6:42 PM, Dilip Pandey wrote: > Hi Mr.Joshi, > > Use below formula > > ="Manufacturer of "&A3 > > Solved spreadsheet is also attached with this email. Please get back in > case of any queries. Thanks. > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA

$$Excel-Macros$$ Hi all

Hi, All, I am fresher in ms excel & wanted to learned how to prepared Pivot table & report in Msexcel -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* --

Re: $$Excel-Macros$$

Do you have a sample of how you want to use it? Thanks, Jacob On Aug 27, 9:22 am, Manoj Kumar wrote: > hellloo experts > i want to use sum fuction in macro but without giving a cell referance >  i want sum in a column > > On 8/21/10, Jai wrote: > > > > > Hello Experts > > > Can you Tell me tha

$$Excel-Macros$$ Need Help

Hi All, Please assist in this concern i wanted to prepare excel macro where in i can consolidate different excel workbooks data into one excel workbook. so please send me if it is possible through vba macros.if any one of the group is having the script or macro for performing this activity please

Re: $$Excel-Macros$$ How to Use Vlook with String

Hi All, Do not proper result. due to name is repeated in data than vlookup repeat same all time when ever get same name. sumproduct also calcuate same as vlookup. Thanks, Prabhakar Thakur New Delhi +919953736776 On Fri, Aug 27, 2010 at 6:25 PM, Dilip Pandey wrote: > Hi Pr

Re: $$Excel-Macros$$ Need help in consolidating different excel workbooks in to one work book

Hi Raj, I have copied the following from a site earlier (dont remember the URL) i had a requirement identical to yours Ensure that the consolidation master file(this macro is present) and the other files are saved in a single folder Other details are self explanatory Hope the below co

Re: $$Excel-Macros$$ Code to enter value in multiple worksheets

Wow! This works great. The advantage of not always having to specify the sheet when using Named Ranges never occurred to me. As for this line: c As Range I would have expected to see something like 'c As Cell', but I guess in Excel terms a cell is a range (albeit a very small one)? Thanks much.

RE: $$Excel-Macros$$ Validation rule and 'X'

Hi, Yes, it's possible to have more than one rule. Let me know what it is you actually need, and I'll try to help you acheive it. Regards - Dave. > Date: Fri, 27 Aug 2010 07:53:14 -0700 > Subject: Re: $$Excel-Macros$$ Validation rule and 'X' > From: janes...@gmail.com > To: excel-macros@googl

Re: $$Excel-Macros$$ Validation rule and 'X'

Hi Dave, The first solution was exactly what I needed. Works great. Now, is is possible to have more than one validation rule per cell, perhaps by creating an array in the Formula box under Validation / Settings? Hane -- --

$$Excel-Macros$$ Re: Help!?

On 25 Aug., Mike wrote: > Thanks in advance! > 1. I am using MS Excell 2007 > 2. Problem: I have a Column of serial #'s and they are listed low to > high. Some of the Serial # are listed once, some twice and some 3 > times. > 3. I want to alternate shading for each set of the same serial #'s. > > E

Re: $$Excel-Macros$$

hellloo experts i want to use sum fuction in macro but without giving a cell referance i want sum in a column On 8/21/10, Jai wrote: > Hello Experts > > Can you Tell me that how can Hide the One Cell in Excel in Sheet. > > -- > Thanks For Mail. > > -- > --

Re: THANK YOU $$Excel-Macros$$ Lookup Multiple values and display horizontally

welcome dear. Regards Ashish koul akoul.blogspot.com 2010/8/27 ҉Shine > Hi Ashish, Bruno & Maries > > Thanks a lot I appreciate your help. All the three solutions work. > > Thank you :) > > Shine > > On 25 August 2010 05:06, Bruno Bruno wrote: > >> See if this helps. >> >> Regards, >> Br

Re: $$Excel-Macros$$ Help Required!

Hi Ashish, Am still getting compile error since i am using microsoft outlook 2000 version. Can this code work in 2000 version or I should execute this code using 2007 version. Please advice me. Thanks, Sharma On Fri, Aug 27, 2010 at 1:51 PM, ashish koul wrote: > > > On Fri, Aug 27, 2010 at 1:3

$$Excel-Macros$$ Need help in consolidating different excel workbooks in to one work book

Hi All, Please assist in this concern i wanted to prepare excel macro where in i can consolidate different excel workbooks data into one excel workbook. so please send me if it is possible through vba macros.if any one of the group is having the script or macro for performing this activity please

Re: $$Excel-Macros$$ Give a Solution

Hi Mr.Joshi, Use below formula ="Manufacturer of "&A3 Solved spreadsheet is also attached with this email. Please get back in case of any queries. Thanks. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New De

Re:THANK YOU $$Excel-Macros$$ Lookup Multiple values and display horizontally

Hi Ashish, Bruno & Maries Thanks a lot I appreciate your help. All the three solutions work. Thank you :) Shine On 25 August 2010 05:06, Bruno Bruno wrote: > See if this helps. > > Regards, > Bruno > > 2010/8/24 ҉Shine > >> Thank you Ashish. I appreciate your effort and time you spent for i

Re: $$Excel-Macros$$ How To Find Duplicate Records in Ms Excel

Dear Rajput, It depends if you want to just see the duplicate records OR you want to do some calculation / analysis on them, accordingly you need to choose the answers. Conditional formatting will highlight the cells and Advance filter can extract the unique set of data and so on..!! -- Thanks

Re: $$Excel-Macros$$ How to Use Vlook with String

Hi Prabhakar, Please provide the sample file for this. Thanks. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Aug 27, 2010 at 12:59 PM, prabhakar thakur < prabhakarthak...@gmail.

Re: $$Excel-Macros$$ How To Find Duplicate Records in Ms Excel

Hi Pankaj, Go to advanced filters and select Unique records Regards Umesh On Fri, Aug 27, 2010 at 11:21 AM, rajput wrote: > I have a lot of Data including number & Alphabet , I am confussed > that duplicate will be entered,,,which command i find duplicate records > > -- > > -

Re: $$Excel-Macros$$ Help Required!

in reference select Microsoft outlook Regards Ashish koul akoul.blogspot.com On Fri, Aug 27, 2010 at 10:06 AM, amrahs k wrote: > Hi Koul, > > Thanks a lot for your effort and time. I have a response for the below > code. > > I get compile error: Can't find project or library while running m

Re: $$Excel-Macros$$ How To Find Duplicate Records in Ms Excel

Please attach the example file Chandra Gupta Maurya On Fri, Aug 27, 2010 at 11:21 AM, rajput wrote: > I have a lot of Data including number & Alphabet , I am confussed > that duplicate will be entered,,,which command i find duplicate records > > -- > > --

$$Excel-Macros$$ How to Use Vlook with String

Dear All, I have a query for using Vlookup with Array like using Vlookup with Name they have not any unique Data using. Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- Some important l

Re: $$Excel-Macros$$ How to find duplicate records in excel

Dear Pankaj Please select the range where your data is. Then PRESS ALT,H,L,H,D. Now you can highlight duplicate values any color. Chandra Gupta Maurya On Fri, Aug 27, 2010 at 11:04 AM, Pankaj Kumar wrote: > > Its cannot help me i provid you an example ; help me to find duplicate >> records >

$$Excel-Macros$$ Give a Solution

Dear All, In Attached sheet Product column starting word *Manufacturer of *are same in every Product colum. give me solution for that without copying how to add this word every time. Regards Mangesh -- -- Some imp

Re: $$Excel-Macros$$ How to find duplicate records in excel

Hi Formula: = IF(COUNTIF(A$2:A$39,A2)>1,"Duplicated","") And if u want to delete duplicates u can use remove duplicate from data from menu ribbon in excel 2007 1. Copy your range of data to a blank section of the worksheet 2. Select a cell in your data set. 3. From the Data ribbon, choos

RE: $$Excel-Macros$$ Validation rule and 'X'

Hi, First of all, you can't use Data Validation after the data is entered. You may apply the validation, but it won't react to invalid data. It only responds to data entered after the validation rule is in place. If you want to be alerted to invalid data that is already present, you'd probably

RE: $$Excel-Macros$$ Need help deleted column in excell sheet

Hi, Do you back-up regularly? If so, it may be in your back-up files. If not, then it is lost lost. Sorry. Regards - Dave. > Date: Fri, 27 Aug 2010 05:24:43 +0400 > Subject: $$Excel-Macros$$ Need help deleted column in excell sheet > From: idhrees...@gmail.com > To: excel-macros@googlegroups.