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...
originally, the sheets named were 2020,2021,2022,2023
melkhor17 There are hundreds of templates out there. which one are you using? Can you upload it here?
Hi Riny_van_Eekelen the copy is what i intend to edit and the other is the original template. have tried to use data validation but doesn't seem to work.
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.
