See Ron de Bruin's Copy/Paste/Merge examples.

http://www.rondebruin.nl/tips.htm

Maybe specifically this page.

http://www.rondebruin.nl/copy1.htm


Gord Dibben MS Excel MVP

On Wed, 11 Feb 2009 14:38:01 -0800, MrRJ
wrote:

Hi,
I have a spreadsheet that I would like to dissect into smaller reports based
on certain criteria in several columns. What is the best approach to this?
Create a macro, if so, can you give me an idea on howabout to do so?
There are 20+ columns and more than 5000 rows.
I can filter certain things in several different rows. After I am done with
my filters, I want to copy the end product to another sheet or file.

I welcome suggestions on the best approach to get this done.
MrRJ