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