Afternoon, I am hoping someone will be able to provide a solution for me.
Each month I set up a new workbook with my dashboard on the first tab and the data needed in subsequent tabs (material, production etc) . This is a long process at the moment as when I copy the old months dashboard it brings the old formuals.If you take a look at my sample workbook (Im currently setting up for September) you will see that in cell F7 the formula is referencing Auguts workbook. Usually I have to manually update each formula to make sure the links are correct.
Is there anyway to speed up or avoid this issue entirely? I wish thinking I could create a master file that is bank (formuals in place but not link to any Month)
Any ideas would be appreciated
Thanks
Bookmarks