Data Download

  • Thread starter Thread starter Chriso
  • Start date Start date
C

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
 
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
 
Back
Top