Ok, so i'm making this great little cost statistics calculator which is going to make my life so much easier at work and i'm almost 100% happy with what ive got bar one little thing.
I need to use a new workbook each week as I still need the info saved before and after the applicable week, and I dont really want to save dozens of copys of the book in sub folder after sub folder. what I was hoping to do was have it set so that I can have three drop down menus on the first page, in which I could select the week (being 1-5) the period (being 1-12) and the year (being FY09,FY10,FY11 ect) and then I would be refreshed with a new sheet so I can enter the applicable data but still be able to go back to old weeks/periods ect.
Is this posible? and if so would it take up less space as it may not have to save all the formating over and over?
Please help!!!
p.s. I could send a copy of my calc if it would help......
Bookmarks