Okay, apologies for the odd thread title but I don't know how else to explain my issue.
I have a financial model that drives P&L, BS and CFlow for the business. It is made up of multiple data tabs, one of which is a salary tab. The salary tab has all employees salary costs and benefits for the year broken down by month. Therefore, if I change any of these values or remove/add an employee it will immediately update all values in the model.
I now want to create a scenario whereby from August to December certain employees will be removed from the business, thus removing all associated costs and showing an improvement to cash flow. BUT, I easily want to switch between this scenario and the current scenario whereby these employees remain within the business.
Having reviewed scenario options within Excel I can't see how to set this up for this specific problem. I also recorded macros of the values being removed, then reinstated, but when I hit the command buttons it totally messed up the model so perhaps that isn't an option.
Could anyone please advise on the best way forward? It seems relatively simple to me, I literally want two command buttons on the executive summary. One stating 'Pre-Restructure' one stating 'Post-Restructure' and literally switch between the two scenarios at will.
Hope the above makes sense, can't really attached an example as such.
Thanks
Simon
Bookmarks