Good Evening all,
I've not been on here for a wee while so I apologise in advance for my lack of knowledge regarding Excel. I am hoping that someone may be able to help me with a query that I may have.
I cureently am using 12 excel documents throughout a year - these documents aresaved on my Desktop and a named Jan, Feb, Mar etc...
When you open the file for that specific month, there is then 30/31 tabs depending on how many days of the month there are. All I simply do is, select the current month, then the current day and then record my relevant information on the Spreadsheet.
To cut down on all this hassle of having 12 different documents, i am wondering if there is a option to have 1 main document, which, when opened, on the 'home page', I can press a buton for the current month and this will then open up the requested months spreadsheet, with all the days of that month on.
Is this something which is possible, or am I just being too ambitious.
I have attached a copy of the Worksheet, which I have just duplicated 12 times, so that you can see what I mean!
Any help/advice/comments would be gratefully appreciated.
Kindest Regards,
Mark
Bookmarks