Re: $$Excel-Macros$$ How to use Vlookup in macro

2011-05-09 Thread maulik desai
thanks sir,but can u tell me that how to use in many columns, i means how can i define column name because i have many columns in that i have to apply vlookup request,can u to plz send me the solution in excel file it will be very helpful for me.one more thing iwant to ask u that i want a macro fo

Re: $$Excel-Macros$$ How to use Vlookup in macro

2011-05-09 Thread maulik desai
thanks sir,but can u tell me that how to use in many columns, i means how can i define column name because i have many columns in that i have to apply vlookup request,can u to plz send me the solution in excel file it will be very helpful for me.one more thing iwant to ask u that i want a macro fo

Re: $$Excel-Macros$$ How to use Vlookup in macro

2011-05-08 Thread rajan verma
Dim LookUp_value as variant Dim LookupVector as range Dim ColNum as Integer Dim ans as Variant 'Assign the Values to Variables Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0) On Sun, May 8, 2011 at 4:45 AM, STDEV(i) wrote: > It would be easy for anyone in the group to respo

Re: $$Excel-Macros$$ How to use Vlookup in macro

2011-05-07 Thread STDEV(i)
It would be easy for anyone in the group to respond, if you can send a set of sample data. On Sat, May 7, 2011 at 1:47 PM, maulik desai wrote: > Hi All, > > I have excel database sheet > I have created some excel output sheets (around 35 excel sheets) which > gives me output data with the help

Re: $$Excel-Macros$$ How to use Vlookup in macro

2011-05-07 Thread vijayajith VA
Hai Will you send a copy of worksheet... Thanks On Sat, May 7, 2011 at 12:17 PM, maulik desai wrote: > Hi All, > > I have excel database sheet > I have created some excel output sheets (around 35 excel sheets) which > gives me output data with the help of Vlookup fuction. > But the problem is i

$$Excel-Macros$$ How to use Vlookup in macro

2011-05-07 Thread maulik desai
Hi All, I have excel database sheet I have created some excel output sheets (around 35 excel sheets) which gives me output data with the help of Vlookup fuction. But the problem is in every 3 months I have to change the database month name & because of that I need to change the vlookup range also