Hi,
I'm really stuck with something I'm developing.
So, I have put together a timesheet for our project staff. Because it has hourly rates of pay etc on it for the Project Manager to see how much each task is costing in staff time, I have had to put together a separate workbook for the PM that draws off of these timesheets, that only they have access to.
I used "Get Data" to pull from my time sheet template to another workbook for the PM.
What I want to know, is there a way of duplicating this easily, so that if my staff use the template and copy it across for their own uses, it copies across the link to the PM workbook too without having to manually link it each time?
Any help would be great! Thank you in advance!
