Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an Excel Spreadsheet that has several worksheets. The layout of each
sheet represents different levels of the organization. At the top of each sheet are the same cells that allow inputing 5 data points to project changes in the results in all of the worksheets. I have the data at the top looking up the data on the initial page. So if the user wants to change a scenario, they have to go back to the first page, make the change and come back. Is there a way to have one data entry point that feeds all of the pages and the user does not have to jump around to make that entry? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You might try looking into Tools-Scenarios, as it sounds like something very
similar to what your are wanting. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dave" wrote: I have an Excel Spreadsheet that has several worksheets. The layout of each sheet represents different levels of the organization. At the top of each sheet are the same cells that allow inputing 5 data points to project changes in the results in all of the worksheets. I have the data at the top looking up the data on the initial page. So if the user wants to change a scenario, they have to go back to the first page, make the change and come back. Is there a way to have one data entry point that feeds all of the pages and the user does not have to jump around to make that entry? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locking a cell after data entry (Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2007/2003 - Automated value entry | Excel Discussion (Misc queries) | |||
How do you find an entry in a Excel 2007 worksheet? | Excel Discussion (Misc queries) | |||
Excel 2003/2007 paste special values shows bizarre results | Excel Worksheet Functions | |||
Report row results based on the last data entry in a column | Excel Discussion (Misc queries) |