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?

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.

--
Lori


"Anne" wrote:

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?

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 EditPaste SpecialPaste LinkOKEsc.

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


Gord Dibben MS Excel MVP


On Wed, 19 Dec 2007 10:24:01 -0800, Anne wrote:

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?