Hi Eveyone,
Good Morning! I need with editing some codes. I got this code from a previous thread. But Im really having problem editing the code.
I do not know how to apply the formula from the macro into all cells. It gives me the same result in all cells.
The macro applies "=VLOOKUP(C8,'[Employee Database.xlsx]Employee Database'!$C:$X,22,FALSE)" this formula in all cells in column E.
Is there a way to change this like as if it was being dragged in a simple excel.
Sample
Cell E8 will apply =VLOOKUP(C8,'[Employee Database.xlsx]Employee Database'!$C:$X,22,FALSE)"
Cell E9 will apply =VLOOKUP(C9,'[Employee Database.xlsx]Employee Database'!$C:$X,22,FALSE)"
Cell E10 will apply =VLOOKUP(C10,'[Employee Database.xlsx]Employee Database'!$C:$X,22,FALSE)" and so on. . . . .
Please help me out on this. . .
sample tracker.xlsm
Bookmarks