Hi,
am trying to implement the excel vlookup function into my vba command. There are two different excel sheet,book1 and book2. both the excel sheets are dynamic i.e. everyday there will be a row increase in book1 and there may be an increase or decrease in rows in book2The formula will be=VLOOKUP(A2,$A$2:$B$64,2,0) for cell Q2
The output will always be in book2 in column Q starting from Q2
The look_up value will always be in book2 from column A starting from A2
The table_array will be in book1 starting from A2:B2 the row length is dynamic, according to the row length of column A & B
Autofill Column Q with the formulas
How can i solve it
am trying to implement the excel vlookup function into my vba command. There are two different excel sheet,book1 and book2. both the excel sheets are dynamic i.e. everyday there will be a row increase in book1 and there may be an increase or decrease in rows in book2The formula will be=VLOOKUP(A2,$A$2:$B$64,2,0) for cell Q2
The output will always be in book2 in column Q starting from Q2
The look_up value will always be in book2 from column A starting from A2
The table_array will be in book1 starting from A2:B2 the row length is dynamic, according to the row length of column A & B
Autofill Column Q with the formulas
How can i solve it