Hi,

Everyday we are openning new accounts.
Jan 1st 2004 we had 500, today we have 1200, tomorrow maybe 1207 etc...
Some people close there accounts too.

Regards.

"Ken Wright" wrote:

Sorry but you have me slightly confused as to numbers.

Yes there are only 65Kish rows in a worksheet

When you say 1200 records for todays file and 500 for first years I'm not
quite sure what you mean. Is that 1200 purely for today, and then possibly
1200 for tomorrow and so on, so potentially 1200*365 records? What is the
500?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip