merge 2q with 2q, then 2q with 2r, then merge 2s plus same text in each then same for rows 3,4,5,6,

edcull · #1 09-27-2016, 08:07 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge Table Rows	npalmer610	Word VBA	2	02-24-2016 04:44 PM
mail merge multiple rows within a grouping	tracygleghorn	Mail Merge	12	11-12-2015 06:43 AM
Formula that can merge multiple rows with the same ID into one row	Hilwey	Excel	3	07-08-2015 08:50 PM
Mail merge into table with two colums and several rows	kathriiin	Mail Merge	3	03-30-2015 07:06 AM
Mail Merge multiple rows?	ender541	Mail Merge	1	08-21-2012 03:14 PM