You might be able to us a vlookup if you have a seperate line per course for
the "Smiths"- if you have Smiths then course 1,4,8 it's more difficult
i.e you want the info to be
smith 1
smith 4
smith 8
the you can use the vlookup up to bring in the course info
--
Thanks for your help


"tdart" wrote:

I have two worksheets, one is a catalog of data (fields of party names, party
number, date of party and party hosts) - next worksheet contains fields of
participants and which party number they signed up for. Is there a way to
merge the two sheets to create a 'receipt' for each participant.? ie, The
Smith family signed up for cookie decorating, book club and surf-n-turf
dinner.
Thank you.