Linking contents of Worksheets

[Deb]

This is no doubt a very simple thing but I cannot remember how to d
it nor can I find it in Help

I created a spreadsheet (worksheet) named MASTER. Then added 3 other worksheets to the workbook. I named them PP1 (worksheet 2), PP2 (worksheet 3), PP3 (worksheet 4)
If I make a change to the first worksheet, or add a row or column to the first worksheet, I want the related cell(s) in worksheets 2, 3 and 4 to automatically be changed as well, so that I don't have to make the changes manually on both sheets. How do I do this

 

[Michael]

Hi Deb
Highlight the first sheet Tab
Hold down Shift key and click on last sheet.
When all sheets are highlighted, make your changes.
This will then affect all highlighted sheets.

Regards
Michael

-----Original Message-----
This is no doubt a very simple thing but I cannot remember how to do
it nor can I find it in Help.

I created a spreadsheet (worksheet) named MASTER. Then

added 3 other worksheets to the workbook. I named them PP1
(worksheet 2), PP2 (worksheet 3), PP3 (worksheet 4).

If I make a change to the first worksheet, or add a row

or column to the first worksheet, I want the related cell
(s) in worksheets 2, 3 and 4 to automatically be changed
as well, so that I don't have to make the changes manually
on both sheets. How do I do this?

 

[PLN]

Hold down the shift key and select the tabs for the
worksheets you want the change to appear on. The change
will occur on all tabs you have selected.

-----Original Message-----
This is no doubt a very simple thing but I cannot remember how to do
it nor can I find it in Help.

I created a spreadsheet (worksheet) named MASTER. Then

added 3 other worksheets to the workbook. I named them PP1
(worksheet 2), PP2 (worksheet 3), PP3 (worksheet 4).

If I make a change to the first worksheet, or add a row

or column to the first worksheet, I want the related cell
(s) in worksheets 2, 3 and 4 to automatically be changed
as well, so that I don't have to make the changes manually
on both sheets. How do I do this?

 

[Cindi]

Hold down the shift key and select the tabs for the
worksheets you want the change to appear on. The change
will occur on all tabs you have selected.

No, this isn't doing what I want. This method changes the
corresponding same CELL on all the sheets. My sheets are sorted
differently, it's changing the same CELL but not the appropriate same
CONTENTS.

Example:

Tab 1--sorted by name (Column A)
Column A Column B
Jones 01/01/01
Smith 03/05/00
Robinson 02/10/04
Williams 12/13/99

Tab 2--sorted by date (Column B)
Column A Column B
Williams 12/13/99
Smith 03/05/00
Jones 01/01/01
Robinson 02/10/04

If Jones changes her name, I want to change it only once, for
instance, go into Tab 1, click on A1, type the new name, and have it
change accordingly on Tab 2 (where it's now A3).

Any suggestions?

 

[Peo Sjoblom]

Just link to the other worksheet

=Sheet1!A1

 

[Guest]

Thanks,

That works for me.
Deb

-----Original Message-----
Hi Deb
Highlight the first sheet Tab
Hold down Shift key and click on last sheet.
When all sheets are highlighted, make your changes.
This will then affect all highlighted sheets.

Regards
Michael
added 3 other worksheets to the workbook. I named them PP1
(worksheet 2), PP2 (worksheet 3), PP3 (worksheet 4).
or column to the first worksheet, I want the related cell
(s) in worksheets 2, 3 and 4 to automatically be changed
as well, so that I don't have to make the changes manually
on both sheets. How do I do this?
.