In Excel how do I update cells in multiple sheets simultaneously?

[kjh1210]

I have muliple sheets within a workbook with lists of names and addresses. I
am trying to find a way to update addresses on all sheets simultaneously if I
am making a change to an address on the first sheet. I don't want to have to
copy and paste address changes to each separate sheet in the workbook.

 

[Victor Delta]

I have muliple sheets within a workbook with lists of names and addresses.
I
am trying to find a way to update addresses on all sheets simultaneously
if I
am making a change to an address on the first sheet. I don't want to have
to
copy and paste address changes to each separate sheet in the workbook.

Use references for the names and addresses on subsequent sheets.

For example, say the names are in Col A of Sheet 1. If you want to duplicate
the names in Col A of Sheet 2, enter "=Sheet1!A1" (without the quotes) in
cell A1 of Sheet 2 and copy down the column.

When the cells on Sheet 1 are amended, the corresponding cells on Sheet 2
will update automatically.

Hope this helps,

V