Sharing infor between worksheets based on terms

T

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
 
T

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

'Dave Peterson[_2_ said:
;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?



-
 
D

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

'Dave Peterson[_2_ said:
;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?



-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top