Dear all,
I have build a model in excel with several tabs of reference data and one cover sheet to run scenarios.
When I run a new scenario, I copy the blank cover sheet and rename it. This results in numerous tabs (25+) with different scenarios.
The question:
I want excel to automatically calculate the 'active' scenario sheet in real-time (so no F9 or Shift+F9 required), without recalculating all previous scenarios and reference files. This for performance proposes.
In other words; "How can I put the active sheet on 'automatic', without calculation the entire workbook".
I am sure it can be done with some VBA, but I am complete clueless how to use it.... so a simple step-by-step plan would be highly appreciated.
Bookmarks