how do I apply changes I make on one sheet to other sheets?

A

Anne

I have an Excel document that is really long, so I broke it up into its
different parts and put each part on a separate sheet so it's easy to find.
I'd like to be able to change something on the big list and have the change
applied to the corresponding part on the separate sheet without having to
manually change it. Is there a way to do this?
 
L

Lori

Set up a link between the spreadsheets.
Copy the info from your master list and do a Edit/Paste Special/Paste link
on the other sheets. Try only using the paste link feature on the info you
are going to change. Using the Paste Link feature for the entire worksheet
could make your file very large...depending on the amount of info.
 
G

Gord Dibben

Anne

I would prefer to have one sheet only.

Then you can use sorting filtering functions to pull up certain parts of the
sheet without the need to change multiple sheets when you make a change on the
one.

If you want to use separate sheets you can link the cells or the separate sheets
back to the Master sheet.

See help on "linking".

Probably the easiest would be to select a portion of the Master sheet, copy that
then switch to another sheet and Edit>Paste Special>Paste Link>OK>Esc.

But there are other methods which you will find in help.


Gord Dibben MS Excel MVP
 
Top