wibbers2000
05-15-2007, 03:00 AM
I would like some help on a vlookup loop please.
I can hard code the formula into a cell and drag it
(=VLOOKUP(Full!H1,Jobs!A1:B5000,2,FALSE))
, however, I want a codeless page and would rather it be in vba code.
I have attached a sample and the code is in the full page and column "I".
could some please assist in the code to make it a loop to all rows with data in.
Regards
I can hard code the formula into a cell and drag it
(=VLOOKUP(Full!H1,Jobs!A1:B5000,2,FALSE))
, however, I want a codeless page and would rather it be in vba code.
I have attached a sample and the code is in the full page and column "I".
could some please assist in the code to make it a loop to all rows with data in.
Regards