List Management ???

[Daphtg]

how many 8 column records (as in addresses) will a work sheet hold/ How many
will a workbook hold ?how can you combine sheets into one huge list?

I am working on a list of @ 100,000 names and addresses. I already have
some 25,000 and I don't want to be surprised.

Thank you in advance for your help.

 

[David Biddulph]

You are limited to 65536 rows in a sheet, unless you use Excel 2007. You
can use as many sheets as your memory will allow.

 

[Shane Devenshire]

Hi,

Excel 2003 allows 65536 rows. Excel 2007 allows 1,048,576.

One solution is to store data in Access and connect to it from insde of
Excel either through a database query or a pivot table.