merging two worksheets

T

tdart

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.
 
D

David

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging 2 worksheets (newbie) 1
Merging worksheets 2
Merging Excel file with Word document 6
merging two large spreadsheets 2
merging two worksheets 3
Sorting worksheets by name AND colour 6
Merging worksheets together 1
Combining two worksheets with same case identifiers 3

Top