- Joined
- Feb 17, 2013
- Messages
- 2
- Reaction score
- 0
Please can anyone help me, I have created a workbook in Excel which has a Master Tab called Work Load and then 6 other tabs with staff names on them as-well as and Archive tab.
i have managed to tell the tabs to move over to the archive tab when you input a completed date into a cell but what i need is a why to duplicate everyone's workload onto the mater tab so that i don't have to look at individual tabs to see who is working on what job.
Please can anybody help me with this. I have attached the excel file so you can see what i have done but im stuck on the final hurdle.
Please can anyone help me.
Regards
Paul
i have managed to tell the tabs to move over to the archive tab when you input a completed date into a cell but what i need is a why to duplicate everyone's workload onto the mater tab so that i don't have to look at individual tabs to see who is working on what job.
Please can anybody help me with this. I have attached the excel file so you can see what i have done but im stuck on the final hurdle.
Please can anyone help me.
Regards
Paul