Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel at Work
How do you make it to where you can insert data onto one of the worksheets
and if you copy and paste to another and then go back and update it on the original and it automatically changes it on the other worksheets |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel at Work
"Confuzzled" wrote in message
... How do you make it to where you can insert data onto one of the worksheets and if you copy and paste to another and then go back and update it on the original and it automatically changes it on the other worksheets It's called a "link" and you don't copy and paste. Assume worksheet A and B. You want to replicate data in cell A1 Worksheet A from cel B1 Worksheet B. Open both worksheets. In Cell A1 Worksheet A, type = then with your mouse click on Worksheet B, cell B1. Press enter. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel at Work
Copy then EditPaste SpecialPaste LinkOKEsc
Gord Dibben MS Excel MVP On Thu, 22 May 2008 09:32:01 -0700, Confuzzled wrote: How do you make it to where you can insert data onto one of the worksheets and if you copy and paste to another and then go back and update it on the original and it automatically changes it on the other worksheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |