Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identical Cells in Multiple Worksheets in one Workbook.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identical Cells in Multiple Worksheets in one Workbook.
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identical Cells in Multiple Worksheets in one Workbook.
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identical Cells in Multiple Worksheets in one Workbook.
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting all worksheets in a workbook identical | New Users to Excel | |||
Protection of identical cells on multiple worksheets | Excel Worksheet Functions | |||
Moving cursor to identical cells across multiple sheets | Excel Discussion (Misc queries) | |||
Identical Name on multiple workbook pages | Excel Discussion (Misc queries) | |||
merge/extract data from identical worksheets in a workbook | Excel Discussion (Misc queries) |