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.