Sharing infor between worksheets based on terms

[Tally38]

Hello,
I have a master pipeline and in the Status column there will be term
such as "closed", "approved", "pending", etc. I also have additiona
worksheets in the same workbook titled "closed", "approved", "pending"
etc. I want to be able to look at the master pipeline and see everythin
that was input and have the "closed" rows copied to the "closed
worksheet, the "approved" copied to the "approved" worksheet, etc. Ho
can I do that

 

[Dave Peterson]

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

 

[Tally38]

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

Tally38

;1141885']Ron de Bruin has lots of code for splitting this kind of stuf
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 se 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]

No thanks to the workbook.

Since you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
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

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

;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?



-