Forum Discussion
M2M FORMULA
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.
Riny_van_Eekelen for me to change the P&L tab, do i just use data validation to do the same for me to get 2019 data into it as well?