Forum Discussion
M2M FORMULA
Hi there I have downloaded an excel template for my company profit & loss. However I plan to change the worksheet names to 2019,2020,2021,2022,2023 and so forth. However, when I change the sheet na...
melkhor17 As always, such templates are difficult to amend if you don't dive into them at the deep end. This one has two hidden sheets Control1 and Control2 with hard coded references to tabs 2020 to 2025. Adding a tab with a different name will not do anything to the month-to-month comparison. Quite a silly template IMHO.
I've changed the formulae in the two hidden sheets for you and believe it works now.
Riny_van_Eekelen Thank you so much!! You just made an impossible deadline now nearly possible. God bless you.