Ania has attended:
Excel Advanced course
Linking worksheets
Hello
Could you please help me with linking 3 different worksheets:
1. Worksheet includes basic costs to the company
2. Worksheet needs to include the cost to the client calculated on top of the data from worksheet 1
3. Worksheet includes rounded values based on worksheet 2
Thank you
Ania
RE: Linking worksheets
Hello Ania,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding linking worksheets.
Whenever you wish to link one worksheet to another, you need to place a formula in a cell on the worksheet where you require the value to go. This formula will include a reference to a cell in the other worksheet and after you press enter the result will appear and the sheets are now linked.
To do this...
1) Click on the worksheet cell where you want the result to appear
2) Press = and then begin your formula
3) When you need to use a cell in the other sheet, click the sheet tab then click the required cell
4) You may need to press enter at this point if the formula is complete, however, should you require to use further cells in the first sheet then click the sheet tab, continue with the formula and press enter when finished.
Use this method to link any worksheet with another.
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,
Rodney
Microsoft Office Specialist Trainer
