Data Download

[Chriso]

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

 

[bgeier]

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

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