List Management ???

  • Thread starter Thread starter Daphtg
  • Start date Start date
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple List Analysis 0
Adding up total hours worked on employee schedule using various criteria 0
Location of the first greater than cell 3
single report on data in 20 tables 1
Dependent drop down dynamic range formula, off sheet. 7
vlookup i think 3
Using Drop Down List or Combo Box 9
eliminate duplicates on a sheet 3

Back
Top