Try this & see if it's what you're after
It only works up to Employee7 because that's all there is on the 4WeeklyOverallTemplate worksheet.
There's no buttons to press as it's a worksheet change macro & will trigger when something changes in columns D, E or F.
Adjust anything in columns D,E or F on EmployeeInformation worksheet and the macro will enter the new data on 4WeeklyOverallTemplate worksheet.
The dropbox link is for you to get the file. I can't upload any attachments to this site & haven't been able to for months.
To see the code right click EmployeeInformation worksheet tab & click view code
Cheers
https://www.dropbox.com/s/1842tyxiww...8472.xlsm?dl=0
Bookmarks