I would like to create 2 reports on one worksheet based on data from another worksheet and the selection of a drop down box. I can easily create these manually from the raw data but I need this somewhat automated for someone else to use. They need to be able to choose an option from the drop down menu and the report is generated based on the selection criteria.
For the "Attendee Training Classes" report on the Dashboard_and_Data Entry worksheet, I would like to:
1. Choose an attendee name from the drop down list (already created using Name Manager)
2. Pull the Course Name and Date Attended data from the POST_Data worksheet based on the selection from the drop down menu
3. Report a scrolling list of the results in the "Attendee Training Classes" report area (sorted by date with the most recent at top)
For the "Training Classes by Date" I would like to do the same as above but show Attendee name and Date Attended results for the Course Name chosen in the drop down.
Your help is much appreciated.