View Single Post
 
Old 11-14-2010, 07:51 AM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Scenarios might work well for this. With scenarios, you specify "Changing Cells", and these are the only cells that can change from scenario to scenario. Then create a new scenario, give it a meaningful name and maybe comments, and you will be given the opportunity to change any of the Changing Cells. Repeat for other scenarios. You can then use a drop-down to change what scenario you have on screen. They are very neat.
Reply With Quote