Gurus,

I have a workbook full of event information. The executives at my company
want to have a summary sheet that just lists specific information about key
customers attending each event and want to be able to produce the summary at
any time.

Here's how it would work.

The person producing the summary sheet would enter an event number in a
field in the summary sheet and then click an action button that would run the
macro.

The event number is a value unique to each event. All bookings for that
event (key customers) all share that value in column A of the detailed
worksheet.

Once the macro is finished running I'd want to have populated in the summary
sheet all entries that match the event number, and also the values from
columns L, N, O, R & S in the summary sheet.

The user will print and they would then run the same process for other
events, replacing the information in the summary sheet with information for
the next event.

Any help with this would be greatly appreciated.

Thanks in advance,

Scott