Excel at Work

C

Confuzzled

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
 
G

Gordon

Confuzzled said:
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
Click to expand...


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copy specific rows to different work sheets 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Headers and Footers - How to copy? 1
How to look up and copy a changing range of data ? 2

Top