changing the macro manually every file it is added to is not an option. SO, here is an example
I have an excel file called DATA.xls that contains the lookup data. it is contained in cells A1:D57 and that entire range has been named "data"
the file that i created the macro on had around 300 rows. i used
B1 = VLOOKUP(A1, data, 2, false) and then the fill handle all of the way down... then...
C1 = VLOOKUP(A1, data, 3, false) and then the fill handle all of the way down... then...
D1 = VLOOKUP(A1, data, 4, false) and then the fill handle all of the way down...
Now, if I have a new excel file with say 400 rows and run the macro, it only fills in the info for the first 300 rows. I would like to change the VB to a dynamic number rather than a static number