I have a workbook that has identical cells in each worksheet within the
workbook but not necessarily in the same cell in each worksheet. If I make a
change to a particular cell that is identical throughout all worksheets, I'd
like that same cell to change in all worksheets.

Any help would be greatly appreciated. Thanks.

In that case, on your 2nd thru nth sheet, put =Sheet1!A1

Assumes Sheet1 is your first tab's name and A1 is the cell in sheet1 you
want referenced.

"Randy" wrote:

I have a workbook that has identical cells in each worksheet within the
workbook but not necessarily in the same cell in each worksheet. If I make a
change to a particular cell that is identical throughout all worksheets, I'd
like that same cell to change in all worksheets.

Any help would be greatly appreciated. Thanks.

Randy
You say that you have "identical" cells in each worksheet but that they are
not necessarily the same cell in each sheet. Do you mean that the content
of the cells is identical but that the cells don't have the same address?
If so, are these cell contents unique in each sheet? That is, there is only
one cell with a particular content in each sheet? Otto

"Randy" wrote in message
...
I have a workbook that has identical cells in each worksheet within the
workbook but not necessarily in the same cell in each worksheet. If I make
a
change to a particular cell that is identical throughout all worksheets,
I'd
like that same cell to change in all worksheets.

Any help would be greatly appreciated. Thanks.

Sean,

Thank you so much. That worked perfectly.

Randy

"Sean Timmons" wrote:

In that case, on your 2nd thru nth sheet, put =Sheet1!A1

Assumes Sheet1 is your first tab's name and A1 is the cell in sheet1 you
want referenced.

"Randy" wrote:

I have a workbook that has identical cells in each worksheet within the
workbook but not necessarily in the same cell in each worksheet. If I make a
change to a particular cell that is identical throughout all worksheets, I'd
like that same cell to change in all worksheets.

Any help would be greatly appreciated. Thanks.

Otto,

Thank you so much. Sean's suggestions worked perfectly for me and I
appreciate your help as well.

Randy

"Otto Moehrbach" wrote:

Randy
You say that you have "identical" cells in each worksheet but that they are
not necessarily the same cell in each sheet. Do you mean that the content
of the cells is identical but that the cells don't have the same address?
If so, are these cell contents unique in each sheet? That is, there is only
one cell with a particular content in each sheet? Otto

"Randy" wrote in message
...
I have a workbook that has identical cells in each worksheet within the
workbook but not necessarily in the same cell in each worksheet. If I make
a
change to a particular cell that is identical throughout all worksheets,
I'd
like that same cell to change in all worksheets.

Any help would be greatly appreciated. Thanks.