LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 516
Default TRICKY: different data sets within the same page

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing 2 sets of coulmns on one page Bill Excel Discussion (Misc queries) 3 October 23rd 09 08:28 PM
Print two sets of columns per page AnotherNewGuy Excel Discussion (Misc queries) 11 October 9th 09 12:13 AM
Excel graph 3 sets of data. 2 sets as lines 1 as column? AndyN Charts and Charting in Excel 2 July 11th 08 01:18 PM
Tab function sets me forward one page instead of one row [email protected] Excel Discussion (Misc queries) 2 January 2nd 06 11:16 PM
tricky data entry question Steve Simons Excel Discussion (Misc queries) 0 July 6th 05 09:25 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"