How to make columns in one sheet match columns from another sheet

[Zoe Hu]

I have four columns of data that need to be exactly the same on two
worksheets. How can I make those columns on sheet B be automatically updated
when I make any chage to sheet A. Those changes can be text update, row
insertion/deletion, and ideally, formatting.

Do I need a macro to do this? Does anyone have a similar macro for me to
start with?

Thanks
Zoe

 

[Vibeke]

Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then
paste link in Sheet B) or simply type
=
in a cell in the sheet B and click in corresponding cell in sheet B, enter,
then click and drag the cell down and across.

 

[Mike Rogers]

Vibeke

You can "Group" the two worksheets while updating the first sheet. What
happens to the first will happen to the second. There are some limitations
but I don't think your what is on list is among them. Save a copy and give
it a try. With the first sheet active hold down "ctrl" and select the second
sheet, you will see "[group]" in the blue bar at the top of the page. Now
what you do to the first sheet will happen to the second. REMEMBER to
"ungroup" when you are done by selecting one of the sheets and you will see
"[group]" go away. You can also right click a tab and select "ungroup" to do
the same thing.

hth
Mike Rogers

 

[Vibeke]

That'll teach me to not read a question carefully! You're quite right, thanks!

Vibeke

You can "Group" the two worksheets while updating the first sheet. What
happens to the first will happen to the second. There are some limitations
but I don't think your what is on list is among them. Save a copy and give
it a try. With the first sheet active hold down "ctrl" and select the second
sheet, you will see "[group]" in the blue bar at the top of the page. Now
what you do to the first sheet will happen to the second. REMEMBER to
"ungroup" when you are done by selecting one of the sheets and you will see
"[group]" go away. You can also right click a tab and select "ungroup" to do
the same thing.

hth
Mike Rogers

Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then
paste link in Sheet B) or simply type
=
in a cell in the sheet B and click in corresponding cell in sheet B, enter,
then click and drag the cell down and across.

 

[Mike Rogers]

Vibeke

I had a miss Q!!! That was supposed to go to the op...but I guess
information is information... Keep up the good work!!!

Mike Rogers

That'll teach me to not read a question carefully! You're quite right, thanks!

Vibeke

You can "Group" the two worksheets while updating the first sheet. What
happens to the first will happen to the second. There are some limitations
but I don't think your what is on list is among them. Save a copy and give
it a try. With the first sheet active hold down "ctrl" and select the second
sheet, you will see "[group]" in the blue bar at the top of the page. Now
what you do to the first sheet will happen to the second. REMEMBER to
"ungroup" when you are done by selecting one of the sheets and you will see
"[group]" go away. You can also right click a tab and select "ungroup" to do
the same thing.

hth
Mike Rogers

Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then
paste link in Sheet B) or simply type
=
in a cell in the sheet B and click in corresponding cell in sheet B, enter,
then click and drag the cell down and across.

:

I have four columns of data that need to be exactly the same on two
worksheets. How can I make those columns on sheet B be automatically updated
when I make any chage to sheet A. Those changes can be text update, row
insertion/deletion, and ideally, formatting.

Do I need a macro to do this? Does anyone have a similar macro for me to
start with?

Thanks
Zoe

 

[Zoe Hu]

Mike,

This is so handy. Thanks a lot for the help.

Zoe

Vibeke

I had a miss Q!!! That was supposed to go to the op...but I guess
information is information... Keep up the good work!!!

Mike Rogers

That'll teach me to not read a question carefully! You're quite right, thanks!

Vibeke

You can "Group" the two worksheets while updating the first sheet. What
happens to the first will happen to the second. There are some limitations
but I don't think your what is on list is among them. Save a copy and give
it a try. With the first sheet active hold down "ctrl" and select the second
sheet, you will see "[group]" in the blue bar at the top of the page. Now
what you do to the first sheet will happen to the second. REMEMBER to
"ungroup" when you are done by selecting one of the sheets and you will see
"[group]" go away. You can also right click a tab and select "ungroup" to do
the same thing.

hth
Mike Rogers

:

Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then
paste link in Sheet B) or simply type
=
in a cell in the sheet B and click in corresponding cell in sheet B, enter,
then click and drag the cell down and across.

:

I have four columns of data that need to be exactly the same on two
worksheets. How can I make those columns on sheet B be automatically updated
when I make any chage to sheet A. Those changes can be text update, row
insertion/deletion, and ideally, formatting.

Do I need a macro to do this? Does anyone have a similar macro for me to
start with?

Thanks
Zoe