Extract all data to new workbook then filter and extract to new worksheets

Hi,

I've been playing with this for a bit and had a search around and haven't been able to find the answer to my issue. I have a spreadsheet that contains geological drilling results for different ore bodies. All results go into the one spreadsheet and I'm after a macro that will filter based on each ore body and export the entire rows from each ore body separately to new workbooks. I've had this work, BUT once the new workbooks have been created I would then like to filter based on a certain column and then copy the results into new sheets based on a value ranges of the filtered cell and then rename these sheets to reflect the value range of that sheet (i.e. I want to filter based on a "GMM" value between ranges "<25", "25-50", "50-75", "75-100", "100-200", "200-300", ">300" and have those ranges be the sheet name at the end). I've got a macro, but it fails once the data gets to the new workbook.

Please Login or Register  to view this content.

Thanks for your reply JBeaucaire. That's a much more simplistic approach, however there seems to be something it doesn't like. When I run the macro with your code it fails on the line:

Please Login or Register  to view this content.

When I debug there are rows visible, not just the headers. It gets to the point where it's filtered for the first ore body and then exports this to a new workbook but in the new workbook it has copied ALL the rows from the original workbook, not just the ones that were filtered. So it has hidden rows that will have values that I don't want in that particular new workbook, as the other rows associated with different ore bodies should get copied out to their own workbook...if I'm making sense?

As mentioned above, I was having trouble with this line of code failing:

Please Login or Register  to view this content.

I did a bit of testing and playing and recorded some macros doing what I wanted it to do, to see what would work and what wouldn't. So I've now got a macro that works, as per below. BUT it takes literally 10minutes to run given it's doing a whole bunch of physical copying, pasting etc. I'm just wondering if anyone would please be able to take a look at my code and see if they could streamline it so that it runs a lot quicker but still gives me the same result?

Please Login or Register  to view this content.

Many thanks