Linking sheets + formula

Hello Tina,

Thank you for your question regarding Linking.

If I understand you correctly, you can achieve the result simply. If I had for example a sheet1 with a figure in cell A1, and a Sheet2 with a figure in cell B2, etc.. and I have a Sheet3 that requires the 2 cells mentioned added together, I would type on Sheet3, = then click on sheet1 cell A1, press plus + symbol, click on sheet2 cell B2 then hit Enter. It returns back to where you originated from, Sheet3.
If you look at the formula it will look something like this:
=sheet1!A1+sheet2!B2

You can use autosum, or any calculation in this method. There are other ways of achieving this outcome, using group method if all sheets are laid out the same.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer