Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking sheets + formula
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking sheets + formula
Resolved · Medium Priority · Version 2007
Reply Tue 26 Jul 2011, 18:40Delegate Tina said...
Tina has attended:
Excel Intermediate course
Excel Advanced course
Powerpoint Intermediate Advanced course
Time Management course
Project Management course
Linking sheets + formula
I want to insert gross profit table figures into sheet using tables in 2 other sheets (ie sales, and costs). I linked the 3 sheets together by pressing control and clicking. Then in the relevent gross profit cell clicked = then went to sales sheet and clicked on relevant sales cell. I then typed - to formula and then clicked on relevant cost cell. Although the gross profit was calculated in the right cell. For some reason the same figure but a minus one was inserted into the sales cell. I tried this several times and kept getting the same outcome.
For upcoming training course dates see: Pricing & availability
RE: 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
|