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?

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

I am really a beginner, so I have no idea what the article is telling me. I can attach the workbook if you think you can help me fix it.

Tally38

No thanks to the workbook.

Since you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

On 01/17/2012 20:23, Tally38 wrote:
I am really a beginner, so I have no idea what the article is telling
me. I can attach the workbook if you think you can help me fix it.

Tally38

'Dave Peterson[_2_ Wrote:
;1141885']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





--
Dave Peterson