Show All Occurrences

**Larry.LeBlanc@O** · 08-17-2010, 05:03 PM

The attached workbook has names of courses in column A, locations in column B, and start dates in column C.

I would like for the user to be able to enter a course name in D1, and the records are pulled out of A1:C50 AUTOMATICALLY.

I can do this with an advanced filter extracting to this location, but I don't want to have the user (a novice) run the advanced filter each time.

Any help would be appreciated!

**The Exceller** · 08-17-2010, 05:15 PM

See Attached.

I have used the data validation tool to create a drop down list for your user. Then using the drop down list as the point from which your data pulls, I have used the vlookup function that will automatically show your user the location and date of the course they pick. Let me know if you have any questions.

Best of luck!

**Larry.LeBlanc@O** · 08-17-2010, 05:18 PM

Thanks, but I want to show all ocurrences. (I put that in the title, but forgot to emphasize that in the body.)

Any more thoughts?

**TMS** · 08-17-2010, 05:23 PM

See the attached example. It uses the list of courses as a drop down list and autofilters. It uses a worksheet change event to automate the selection.

It could be tidied up if the unique course names were extracted and used for the drop down list.

Regards