Depends on how are you importing the data.
If you are reading from a database, record by record, then count the
records, when the count = 65536, advance to the next worksheet (do not
forget to test if one is available and create one if there is not one
available.)

You could try filtering the data through your import routine, or before
you start the import.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=540515