Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Outputting rows with a given value to new worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting variable length data - outputting fixed character result | Excel Discussion (Misc queries) | |||
Automate outputting filtered data from main worksheet to another s | Excel Discussion (Misc queries) | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
outputting to multiple worksheets | Excel Discussion (Misc queries) | |||
Comparing contents of two spreadsheets and outputting results to a | Excel Worksheet Functions |