Hi cjaye,
You should consider having all the data on a single sheet and, on another sheet, the formulae used for reporting. Coded correctly, the formulae can retrieve the data for whatever period(s) you're interested in. With over 1million rows to play with, it'll be a long time before the data sheet fills up - and you can always prune the data once they're too old to be of use.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|