View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Outputting rows with a given value to new worksheet

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
---
"erik_gregory" wrote in message
...
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