I am trying to search through a list that is 12 columns wide by 8912
rows. Each row must stay together.

The spreadsheet I have now has drop-downs on the top of the page, but
the drop-down lists do not include all the possible entries in each
column. It only contains approximately 1000 of the first alph-numeric
entries.

Is there a 1000 entry limit on drop-down lists?

How can I get the drop-downs to include all data in the column?

Thanks for any and all help on this.:)


--
prodrafter
------------------------------------------------------------------------
prodrafter's Profile: http://www.excelforum.com/member.php...o&userid=30287
View this thread: http://www.excelforum.com/showthread...hreadid=499557