Data entry that changes worksheet(s) results (2003 or 2007)

[Dave]

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?

 

[Luke M]

You might try looking into Tools-Scenarios, as it sounds like something very
similar to what your are wanting.