merge 2q with 2q, then 2q with 2r, then merge 2s plus same text in each then same for rows 3,4,5,6,
Hi
I am trying to automate a safari supper spreadsheet to print labels telling participants where they are headed next. So, for a starter, the people named in q2 are hosting, the people in r&S 2 are visiting.
The peolpe in q3 are hosting those in R&S 3 etc.
I need to print off slips to put in envelopes to tell people where they are going.
S = starter, M = main and D = dessert.
Can't seem to get it right. spreadsheet attached.
I would be very grateful for some help on this one as this is he stage that usually gets fouled up doing things manually!
Many thanks
Eddie
|