I have a workbook that I basically use as a template. It called Blank2011. At the first of each month the workbook is opened and Saved As the current month (January2011, February2011, etc.).
The blank itself has 40 - 50 sheets within. One of these sheets is called "temperature" and it has various data being pooled from other sheets in the book.
I would like to have set up a brand new workbook that has the same data as the temperature sheet. I can't figure out an easy way to do this. So, it would basically be January2011Temperature, FebruaryTemperature2011, etc.
I could create a Blank for it "TemperatureBlank2011" and rename it every month just as the main book but how would it know to get the info from the correct month???
Any simple way to do this?
The blank itself has 40 - 50 sheets within. One of these sheets is called "temperature" and it has various data being pooled from other sheets in the book.
I would like to have set up a brand new workbook that has the same data as the temperature sheet. I can't figure out an easy way to do this. So, it would basically be January2011Temperature, FebruaryTemperature2011, etc.
I could create a Blank for it "TemperatureBlank2011" and rename it every month just as the main book but how would it know to get the info from the correct month???
Any simple way to do this?
