sindhuja
03-26-2012, 12:25 PM
Hi,
I need to use the vlookup function using macro since the excel file is very large.
I have the column P in sheet 1 to be compared with column A of sheet 2. The results should be in column Q of sheet 1 (insert a new column and name it results).
Once this is done, i need to find and replace the column names in row 2 of sheet1. columns names to be replaced and the value to be replaced are in the sheet named rearrange.
Can someone help me on this urgent requirement pls. . Also it takes long time to run a macro.. is there a way to speed up the time.
-Sindhuja
I need to use the vlookup function using macro since the excel file is very large.
I have the column P in sheet 1 to be compared with column A of sheet 2. The results should be in column Q of sheet 1 (insert a new column and name it results).
Once this is done, i need to find and replace the column names in row 2 of sheet1. columns names to be replaced and the value to be replaced are in the sheet named rearrange.
Can someone help me on this urgent requirement pls. . Also it takes long time to run a macro.. is there a way to speed up the time.
-Sindhuja