 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Listing values that meet a criteria.
Hi, I'm trying to create a list from a worksheet i've made but am unsure how to go about it. The worksheet has a table that gives a rating for different safety issues from a drop down menu (n/a, 1,2,3,4, & 5). I need to be able to list all the ratings that are a certain value Ie. List all the items that have a rating of 3-5 or only the ones that show "n/a" on a different sheet so the user will be able to comment on them separatly. The ratings for the items in the table will differ each time a user uses the document. Any help will be appreciated. Thank you Use AutoFilter. You can make it display only those rows that meet criteria. You can even copy/paste them elsewhere. See: http://www.contextures.com/xlautofilter01.html  SignatureGary''s Student - gsnu200789 > Hi, > [quoted text clipped - 6 lines] > items in the table will differ each time a user uses the document. Any help > will be appreciated. Thank you Thank you for the suggestion however, I need the document to do this automatically for the user so as he gave each item a rating - it would appear automatically in a different page if it was a rating between "1" and "3". > Use AutoFilter. You can make it display only those rows that meet criteria. > You can even copy/paste them elsewhere. See: [quoted text clipped - 11 lines] > > items in the table will differ each time a user uses the document. Any help > > will be appreciated. Thank you Have you thought of using autofilter? You can select the filter criteria (maybe using Custom if you want a range of criteria) and then you can select the visible rows and copy just those to another sheet. Hope this helps. Pete On May 28, 10:00 am, jenna mul <jenna m...@discussions.microsoft.com> wrote: > Hi, > [quoted text clipped - 6 lines] > items in the table will differ each time a user uses the document. Any help > will be appreciated. Thank you |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.