Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ranges A:D have fixed values. Ranges E:M have a mix of user input variables
and formulas. I would like to create a toggle switch that allows a user to switch between two sets of variables. It's essesntially like have two copies of Sheet 1. The first copy would contain one set of data in the cells from E:M and the second copy would contain a separate set of data. Both copies would contain the same data in the cell from A:D. The reason I would like to combine these into one page is because a user may add or delete a row, or may create a different set of fixed values for columns A:D...if this is done on only one page and not the other, the comparisons become skewed. If it is combined into one page, Columns A:D remain constant. Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing 2 sets of coulmns on one page | Excel Discussion (Misc queries) | |||
Print two sets of columns per page | Excel Discussion (Misc queries) | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
Tab function sets me forward one page instead of one row | Excel Discussion (Misc queries) | |||
tricky data entry question | Excel Discussion (Misc queries) |