Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a cell value in a different sheet from several sheets
Hi there,
In my workbook I have several worksheets all containing different reports. In the first worksheet there is a cell which has a in-cell dropdown list as a validation criteria. This cell defines the reporting period for all other worksheets. ie when you change this cell to say 5, all the other worksheets become the reports for period 5. When viewing the reports generated in other worksheets it is inconvenient to go back to the first one and chage the reporting period every time. Is there a way that I can change this cell say A1 in Sheet1 from each individual report worksheets (say from Sheet2, Sheet3, ...Sheet14, etc. appreciate your time. thx ------------------------------------------------ Message posted from http://www.ExcelTip.com/ -- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum -- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/ ------------------------------------------------ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to insert a collum on a sheet without it changing cell referen | New Users to Excel | |||
Mass Changing whole sheets individual cell references | Excel Discussion (Misc queries) | |||
Changing Font in an unlocked cell in a protected sheet. | Excel Discussion (Misc queries) | |||
changing tab from another sheet cell | Excel Worksheet Functions | |||
what is the formula for changing the same cell on different sheet. | Excel Worksheet Functions |