Please help, I have zero knowledge of VBA...
I have a cell (B2-Sheet 1) linked to a vlookup data in Sheet 2 (A1:A100 is the linked ID field), Sheet 1 is an employee statement and B2 is the employee ID
I need a macro that will change the cell B2 to the linked ID field in A1-Sheet2 then print Sheet 1,
then change the cell B2 to linked A2-Sheet 2 then print Sheet 1, and so on until A100
Sheet 1 has many vlookup fields all linked to B2 and a graph chart so the idea is to automaticall print 100 employee statements all with different costs
Can anyone provide the VBA and advise on which parts i need to change ?
Any help would be appreciated
Dele
I have a cell (B2-Sheet 1) linked to a vlookup data in Sheet 2 (A1:A100 is the linked ID field), Sheet 1 is an employee statement and B2 is the employee ID
I need a macro that will change the cell B2 to the linked ID field in A1-Sheet2 then print Sheet 1,
then change the cell B2 to linked A2-Sheet 2 then print Sheet 1, and so on until A100
Sheet 1 has many vlookup fields all linked to B2 and a graph chart so the idea is to automaticall print 100 employee statements all with different costs
Can anyone provide the VBA and advise on which parts i need to change ?
Any help would be appreciated
Dele