Data Download

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

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.