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" wrote:

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.

"Zoe Hu" wrote:

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