excel microsoft training - Link Worksheets

Hi May

Hope you are well
what you need to do

As long as you have a summary sheet for the totals, this is where you need to start writing and creating your links

firstly when you are linking formulas you need to use your mouse and your keyboard to create the formula, and i will show you an example of the formula below:

=E5+Sheet2!D3 this is how the formula looks, but when you create this you will need figures in both of the cells used in the formula then, on a blank cell type =e5+, then click the sheet 2 tab at the bottom of the screen then click on cell d3 when you have done that press enter

Hope this helps

Mark East