Forum Discussion
A Little Help from my Friends
I am an advanced (expert) in Excel. I've used it for over 20 years everyday and have thousands of education hours under my belt. I would like to get some ideas on how some of you would approach this ...
In this sort of situation I would pull data from the 'sub-files'. then have reporting tabs for each month. The 'closing' of a month included a copy and paste-values of all the values for that month and hence 'locking' them in.