Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inputting variable length data - outputting fixed character result Webster Excel Discussion (Misc queries) 2 October 26th 07 04:55 PM
Automate outputting filtered data from main worksheet to another s tiger1022 Excel Discussion (Misc queries) 1 August 1st 07 09:08 PM
Data validation boxes, outputting a final number from the boxes MDH Excel Discussion (Misc queries) 1 November 16th 06 12:41 AM
outputting to multiple worksheets cmumeche Excel Discussion (Misc queries) 0 July 29th 05 08:42 PM
Comparing contents of two spreadsheets and outputting results to a brx Excel Worksheet Functions 5 March 17th 05 01:44 AM


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"