excel course - excel timesheet

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course - Excel Timesheet

excel course - Excel Timesheet

resolvedResolved · Low Priority · Version Standard

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

RE: Excel Timesheet

Thanks a million!!!! It will help a lot in the future.

Regards,


Jass Emmins

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.1 secs.