Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2003
Resolved · Low Priority · Version 2003
Julie has attended:
Excel Intermediate course
Access Introduction course
Can you connect two work sheets so that what is updated in one is automatically updated in the other and if so, how?
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
|
|
Excel tip:Paste functions box quicklyIf you want to do a formula using the paste functions box press SHIFT + F3. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
