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.

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.
--
David Biddulph

Daphtg wrote:
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.

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Daphtg" wrote:

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.