VBA vlookup - dynamic sheet with last row and last column

[jocker_boy]

Hi,

I would like to add vlookup formula with VBA considering:

• We are in "Sheet1"
• The Table Array will be in another sheet, based on the name in cell A2 (In this case "Sheet5")
• It will start in A1
• The D10 is the last row and last column in "sheet5"

The goal is, if i change A2 from "Sheet5" to "Sheet10", i would like to run the macro and fill the Vlookup formula in my rows with the new table array range.

Sheet5
A	=vlookup(A;'sheet5'!A1:D10;2;FALSE)
B	=vlookup(B;'sheet5'!A1:D10;2;FALSE)
C	=vlookup(C;'sheet5'!A1:D10;2;FALSE)

Thanks for the help.
Gonçalo

 

[jocker_boy]

Any ideias?
Please.

Gonçalo