Hello,
I was wondering if someone could help me to pull data from one sheet to another sheet in multiple columns at once using VBA.
- Sheet “Personnel information” contains all active and inactive employees
- Sheet “Data to Upload” contains some of the information from “Personnel Information” and some from “Manually Calculated Data” sheet
I like to perform a VLOOKUP by social security in column “D” in “Data to Upload” sheet and Column “C” in “Personnel Information” sheet to pull data for below columns into “Data to Upload” sheet from “Personnel Information” sheet.
Column J
Column K
Column L
Column M
Column O
Column P
Column Q
Please see attached copy of the sheet.
Thank you in advance for your help.
Bookmarks