View Single Post
 
Old 04-09-2012, 04:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote