Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
always present input form
I have a spreadsheet with 10 output sheets. The output changes
depending upon which product is being analyzed, which is set in a product input cell on the summary sheet. I would like to be able to change the product from any of the 10 output sheets. Any suggestions on how to go about this? I don't like having to flip back to the summary page everytime I want to change products and I prefer to have a solution that is more than just using hyperlinks to simplify the navigation. I was thinking about creating a form that resided on top of the active sheet that would allow for changes in input, but I imagine there might be a better solution. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically display sentence. | New Users to Excel | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Worksheet form design | Excel Discussion (Misc queries) | |||
input form and addition | Excel Discussion (Misc queries) | |||
Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) |