cannot complete with available resources

[datahead]

Hey everyone, I'm hoping you can help me with this.

I'm currently working on an excel file with a lot of data, and multiple columns.

The data needs to be arranged in certain ways for printing and viewing.

As an example:
say that columns A through C are common to everything, so they are copied off the "master sheet" and pasted on all the following sheets I created. After that, the data from column D to E is from one department, so that is pasted on the second sheet next to the common values. Then data from columns F to H is from another department and pasted on the third sheet next to the common values... and so on

What I have done so far is make about 18 different tabs and I have a macro that will take all the appropriate columns and copy and paste them in their respective worksheet tab.

But the data on the "master sheet" can also be filtered using the drop-down menus at the headder of each column.

This is where I run into a problem. When the data is filtered in that fashion and I run the macro, it will work fine up until about the 15th tab and then have an error that says, "excel cannot complete this task with available resources. Choose less data or close other applications."

This just seems strange because after the results are filtered there is less data to be copied and pasted.

Any help would be greatly appreciated, and if it is unclear please let me know how I can clear it up. I cannot paste a sample in here because I cannot make the filesize small enough, so I will try my best to explain it.

thanks in advance

[mrice]

You could try turning the screen updating of to save some resources.

Please Login or Register  to view this content.

[datahead]

Great idea, but unfortunately I still get the error

[mrice]

Could try setting

Please Login or Register  to view this content.

after each copy.


Alternatively you could try a more elaborate route such as having an extra column of sequential numbers, filtering, putting a value into a new column, unfiltering, sorting by the new column, copying to your worksheets, sorting by your sequential number to get the order correct again and refiltering.