Jassiara has attended:
Excel Intermediate course
Excel Timesheet
I'm producing a master timesheet with around 50 architectural projects and I would like to know how is possible to add new projects at anytime in the master timesheet and have all the staff timesheets automatically changed.
Many thanks,
Jass Emmins
RE: Excel Timesheet
Hi Jassiara,
Thank you for the question. What you could do is link the spreadsheets together so that when you change the source data the destination sheet will update. Remember though you need to press save for the system to work out the sheet has changed, it doesn't do it in real time or "as you type".
So to create links simply click into the destination cell (where you what the number to end up) and press = then navigate back to the worksheet containing source information. This links the two worksheets together and can give you a summary sheet of information in your destination sheet.
Hope this helps, let me know
Tracy
