Ron de Bruin has lots of code for splitting this kind of stuff on his site:
http://www.rondebruin.nl/tips.htm

I'd try this first:
http://www.rondebruin.nl/copy5.htm


On 01/15/2012 17:23, Tally38 wrote:
Hello,
I have a master pipeline and in the Status column there will be terms
such as "closed", "approved", "pending", etc. I also have additional
worksheets in the same workbook titled "closed", "approved", "pending",
etc. I want to be able to look at the master pipeline and see everything
that was input and have the "closed" rows copied to the "closed"
worksheet, the "approved" copied to the "approved" worksheet, etc. How
can I do that?





--
Dave Peterson