Hi Team,

I was wondering if someone there could assist me with a small problem.


I'm downloading data into Excel, which is to large for 1 standard
spreadsheet. Is there a program, macro or add-on that you could suggest
that will split the information automatically into multiple
spreadsheets?

Thanks for your help,
Chris


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

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