I'm trying to use a listbox and button to select and display bits of information from an array of data. Let me layout the format of my sheet to make it a bit clearer.

On one sheet I have an array of data, 10 columns by approximately 1200 rows. My columns are headed Course title, date, venue, room, type, letter, start time, end time, learners, and group leader on columns C through L. Below the column headers from row 2 down I have each piece of data.

On a second sheet I have created a Listbox with each of the possible course titles listed. There are multiple instances of each course title however they are all on different dates or locations. I'm looking for a way for a user to be able to click a button after selecting a course title from the listbox and have it populate an area below the listbox and button with every matching piece of data from the array.

I guess it'd be done with a recursive match command but it's been a number of years since I've done any real VBA programming so my skills are very rusty. Any help would be much appreciated.

Thanks.