Realise this is not the most complicated question ever asked:
I've got a set of data (hours worked in 3 roles) that I need to update throughout the week, save at the end of the week, and refresh (empty) ready for the new week. I need my document to automatically store the old data on another worksheet within the same doc, run calculations against this data, (obtain the average hours worked over the year, goal hours to be worked), and show the front worksheet (where the data is keyed).
I created a vast number of Macros to copy, paste, refresh this data, but the Macro always falls down for any number of reasons, partly for being so convoluted. And the graph doesn't work well in conjunction with the macro.
Is there any better way of doing this - am I wrong in using Excel like a storage database?
Bookmarks