have worksheets 2,3,4 auto update from worksheet 1

[Deb]

I have a workbook that has 4 worksheets in it. I want to be able to add a row of information in worksheet 1 and have it update worksheets 2, 3 and 4.

 

[ERB]

I have a workbook that has 4 worksheets in it. I want to be able to add a row of information in worksheet 1 and have it update worksheets 2, 3 and 4.

1. Highlight the cell in worksheet 1 and copy it.

2. Highlight the cell where you want to LINK the information in
worksheet 2.

3. Use the "Paste Special" option and you will get a pop up.

4. Press the "Paste Link" button.

NOTE: If you see a admonition on the bottom of worksheet 2 that says
"Select destination and press ENTER or choose Paste" DON'T DO EITHER!!
If you press ENTER it will paste, but it won't link.

5. Press the Esc key (and the deceptive admonition will disappear)
and the link will be established.

6. Repeat the same process on sheets 3 & 4

 

[sandy]

is there a way for this trick to work after adding or deleting a row in the parent worksheet

----- ERB wrote: ----

On Thu, 12 Feb 2004 09:56:08 -0800, De

I have a workbook that has 4 worksheets in it. I want to be able to add a row of information in worksheet 1 and have it update worksheets 2, 3 and 4

1. Highlight the cell in worksheet 1 and copy it

2. Highlight the cell where you want to LINK the information i
worksheet 2

3. Use the "Paste Special" option and you will get a pop up

4. Press the "Paste Link" button

NOTE: If you see a admonition on the bottom of worksheet 2 that say
"Select destination and press ENTER or choose Paste" DON'T DO EITHER!
If you press ENTER it will paste, but it won't link

5. Press the Esc key (and the deceptive admonition will disappear
and the link will be established

6. Repeat the same process on sheets 3 & 4