excel course - 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