Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2003
|
|
|
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. |
Excel 2003
Resolved · Low Priority · Version 2003
Reply Tue 5 Oct 2010, 12:27Delegate Julie said...
Julie has attended:
Excel Intermediate course
Access Introduction course
Excel 2003
Can you connect two work sheets so that what is updated in one is automatically updated in the other and if so, how?
For upcoming training course dates see: Pricing & availability
RE: Excel 2003
Hi Julie,
Thank you for your question.
Click into the cell that contains the value you would like linked to another worksheet and copy it.
Go to the second worksheet and select the cell you want the value pasted into. Then choose Edit - Paste Special - Paste Link.
This means if the cell you copied from changes, it will automatically update the cell in the other worksheet that you pasted into.
I hope this answers your question.
Regards
Simon
|