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.
|