Outputting rows with a given value to new worksheet

[erik_gregory]

Hello,
I would like to get Excel to sort of "output" rows that has a given value in
it to a different worksheet. Assume there is a drop-down menu in a row. If
the user selects "Yes" from that menu, I would like Excel to automatically
output that row into a pre-prepared worksheet. If the user selects "No," then
I don't want Excel to do anything.

Any suggestions, anyone? Many thanx!
Erik

 

[Max]

Possible, but specifics are required

Can you upload your sample file using a free filehost,
then post a link to it here?

You can use this "easy-to-use" free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here in your reply

(desensitize the data in your sample as required)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik