View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Randy Randy is offline
external usenet poster
 
Posts: 213
Default Identical Cells in Multiple Worksheets in one Workbook.

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.