I've got a massive file with as many as 70,000 rows of data and four pivot tables. The initial file will probably be around 35-40 MB. I need to split this report into 25 different files based on a department identifier. Given the size of the file, there will be considerable time waiting for Excel to keep up.
I've done several projects like this on a smaller scale, so my question is: what is the fastest method to use to keep processing time to a minimum? The options I have used in the past include:
Both options have their drawbacks - it will take forever to copy and paste that many rows, but it also takes a long time to reopen such a big file 25 times.
Does anyone have any suggestions for a quicker method for splitting up a report like this? Thanks for any ideas!
I've done several projects like this on a smaller scale, so my question is: what is the fastest method to use to keep processing time to a minimum? The options I have used in the past include:
- Filter to one department, copy visible rows, paste to an existing template, save and close template, repeat
- Open original file, Save As, filter out department to keep, delete all remaining rows, clear filter, save and close, repeat
Both options have their drawbacks - it will take forever to copy and paste that many rows, but it also takes a long time to reopen such a big file 25 times.
Does anyone have any suggestions for a quicker method for splitting up a report like this? Thanks for any ideas!