What is the most efficient way of breaking a large data set up into categories on worksheets
Posted by Adam K on April 09, 2001 3:30 PM
I have a list of stocks.
In the list, I have a SECTOR field
I want to do a loop and create a worksheet for each SECTOR and paste the data that is in that sector into that worksheet.
I have tried doing a loop where it:
1. autofilters the frontsheet
2. copies visible cells
3. pastes on the appropriate sheet.
PROBLEM: this takes so long. It hangs on the paste for minutes. Also the autofilter takes a while
I have also tried
1. Sorting by SECTOR
2. grabbing a dynamic range of data that fits that sector
3. Copying and pasting this
PROBLEM: Again the pasting takes a very long time. The average amount of data is about 25 rows by 50 columns.
This is killing me.
There has to be an efficient quick way of doing this.
NOTE: I need to copy formulas and formatting.