filtration of worksheets tallying 2 million seperate phone numbers
 

Hi, I am a loan officer at a mortgage brokerage. We have
recently put the new nationwide no-call list on an excel spreadsheet.
I
have 2 questions for you. First: is there a way to make excel have
more
rows than 65,536 (preferably like 2 million) as the colorado part of
the
national no-call list is about 2 million. And second;can you tell me
how to
filter one workshet against a second with 30 columns and 65,536
rows(the
filter feature I use only takes into consideration the left-most
column)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

filtration of worksheets tallying 2 million seperate phone numbers
 

Excel is limited to 65536 rows. You can have multiple worksheets, but that
isn't really very useful for a database. I think you should import your
data into Access. You can still pull subsets of it from access into excel.
In access, you can easily use one database to filter another. You could
set this up as a query and bring that information into Excel.

--
Regards,
Tom Ogilvy



"dabliss74" wrote in message
...
Hi, I am a loan officer at a mortgage brokerage. We have
recently put the new nationwide no-call list on an excel spreadsheet.
I
have 2 questions for you. First: is there a way to make excel have
more
rows than 65,536 (preferably like 2 million) as the colorado part of
the
national no-call list is about 2 million. And second;can you tell me
how to
filter one workshet against a second with 30 columns and 65,536
rows(the
filter feature I use only takes into consideration the left-most
column)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/