Use dropdown list to display more than one record from a table

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

I want to use my dropdown list selection as criteria for searching for all
records that match on another sheet. It will find more than one record to
display.. How do I get it to find all of them in the table and display them.
ie. all products that = nails. It has to be a dropdown list because the list
will change depending on the project so I cannot explicitely say..
criteria=nails.
 
As answered in microsoft.public.excel --

There's a sample file on my web site that uses an Advanced Filter to
extract data to a different worksheet. A macro that's triggered by a
worksheetChange event runs the filter. This might give you some ideas
for your project --

http://www.contextures.com/excelfiles.html

Under Filters, look for 'Product List by Category'.
 
Thank you for the information.. I tried your example.. I just can't seem to
get it to work.. I must be missing my understanding of it somewhere.. I
think the main problem is the Macro in visual basic.. I am not completely
sure what it is doing.. or how to trigger it.. because when I tried.. it
didn't work.. at all.. but thanks.. I will look at it again.. Maybe since
its another day.. I can 'see' better what is going on. Your site is an
excellent resource by the way.. I used it to find my unique records.. I just
can't figure this bit out..
 
What version of Excel are you using? If you're using Excel 97, selecting
an item from the data validation dropdown doesn't trigger a
Worksheet_Change event, so that might be the problem.
There's a separate version of the sample workbook that has a solution
for Excel 97.
 
Debra:

It was the 'tired brain' problem I think... because this morning I walked
through your example again.. Step by Step.. and through the macro.. and
thought about what it is doing... and it made sense this time.. I got it to
work.. Thank you, thank you.. I just have one more obstacle.. and this will
work perfectly.. p.s. I have Excel 2002.

I am not sure its possible.. but.. I would like my workbook to be able to
hold more than one requisition... The boss would prefer to have ONE
job/workbook contains all the requisitions for it based on the Parts List
for that job. I thought about making one sheet a template...of sorts.. which
they can make copies of as needed in the same workbook... but with the
criteria a paste link.. it would change for one.. but not the others...
hmmm.... my last hurdle.. so close, yet so far..

They have to be able to order these parts from various suppliers... and
don't want multiple requisitions.. all over the place.. How could I get it
so that if they made a copy of the requisition template sheet. Can all the
requisitions be all stored in the same workbook as well as the parts list?

Does this make sense.. I know what I want in my head.. but... not sure I am
putting it to print as well...
 
Cheryl,

From your description, it sounds like you could create a table that
contains the details for each requisition, then set up a requisition
form that displays details for the selected req#.

One of my sample workbooks uses this technique:

http://www.contextures.com/excelfiles.html

Under data validation, look for 'Invoice for Selected Number'

Debra
 
Back
Top