Hi cjaye,
What I said was:
Quote:
|
You should consider having all the data on a single sheet and, on another sheet, the formulae used for reporting.
|
With this approach,
no macros are needed - it's simply a matter of re-writing the formulae so that they summarize the appropriate month's data from the data sheet. Plus, there's no need to hide anything and, in the longer term, you'll end up having more data for trend analysis, etc.