Monthly reports

Hey guys,

I am collecting monthly data. I was wondering what is the best method of reusing a workbook, with multiple sheets, for the next month? Some columns are manually entered, others have formulas to do calculations. I understand until there is data these formulas may error. Just wanted to see if anyone had a suggestion as to the best method to do this. Any thoughts, ideas, or suggestions would be greatly appreciated.

Thanks

BRIZZLE

I would enter all data that won't change and your formatting and save the file as your template. Then open it each month and save with that month's name to enter the data that will change from month to month. If having formulas error bothers you while you're working with it, you can put the entire formula inside an IFERROR function.