Hi All -
I am working on a Financial Model and have the following problem:
There is a 'Reporting' tab in the model that collects data from different other tabs. - In particular, there is a series of formulas that receives inputs from a tab called "LoB".
Example A:
=IF('LoB'!K20="";J180;'LoB'!K20)
Example B:
='LoB'!K4
I have now added two sceanario-tabs (versions) of the 'LoB' to the model. These tabs are labelled 'Lob1' and 'Lob2'.
Question: How can I replace in all 2'500 formulas above the 'LoB'!-reference with an IF formula that allows the selection of the scenarios.
e.g. how can I change the formula above (Example B) into:
=IF(scenario=1;'LoB1'!K4;'LoB2'!K4)
Main issue: the solution would have to work for Example A (above) as well.
I have tried to solve the problem with a macro that is able to replace all of the 2'500 formulas, but haven't found a solution yet.
Any help would be very much appreciated! - Thank you.
Rgds,
Alain
Bookmarks