Thanks to all!

YES! I am trying to force something into Word that it doesn't want to do.

I already put another column on the worksheet: "UICROOM" (UIC & ROOM)

I can now run a merge report which contains the names of individuals in the
same UIC & ROOM -- but I've only been able to do it on plain paper.

I need to get this list of names on the second page of a 2-page form (the
first page contains UIC, BLDG, ROOM and many, many rows/columns of other
static data)

I've spent MUCH time trying to get Word to automate this.

If there is a way to do it, a large cell with a stacked list of names
associated with "UICROOM" will allow me to do an easier, much simplified
merge.

BTW: I have no problem getting the UIC, BLDG, ROOM on the first page and I
can get a single name assigned to each UICROOM on the second page. I need
ALL names associated with the UICROOM.

Suzanne


"Suzanne" wrote:

I have a worksheet whe
Row 1 is the header row
A2:Axx is UIC
B2:Bxx is BLDG
C2:Cxx is ROOM
D2:Dxx is LAST [name]
E2:Exx is FIRST [name]
F2:Fxx is MI [middle initial]

I've tried to get a merge to work in Word, but have been told what I need to
do is impossible (Word cannot merge data from two separate fields). So,
perhaps this might work from the Excel side.

I'm holding out for some hope that Excel can group multiple values on
another worksheet -- otherwise, I'm stuck having to copy paste data onto each
form in Word. Can I get the following results from Excel?:
Column A: UIC & BLDG & ROOM
Column B: LAST & FIRST & MI

The UIC & ROOM will always be in the same BLDG
The UIC is not the same for each ROOM (this is what Word merge can't do)

The output would look something like:
(Header Row)
A1: UIC; BLDG; ROOM
B1: LAST, FIRST, MI

A2: W1234; 456; 12A
B2: Jones, Mary L
Smith, Joe S
Doe, Adam D

A3: W3456; 456; 12A
B3: Black, Alan F
White, Barbara T

A4: W3456; 456; 99A
B4: House, Jill S [and so on]

You see that:
o The BLDG stayed the same for all three rows;
o Rows 2 & 3 have the same ROOM;
o Rows 3 & 4 have the same UIC but not the same room;
o The names column B are stacked (not one long string)
o There is a separate form for each UIC + ROOM

BTW: I also have the form in Excel whe
(First page)
K3 = UIC
P3 = BLDG
U3 = ROOM (note: I can merge these together if needed)
(Second page)
A52:Axx = LAST
G52:Gxx = FIRST
N52:Nxx = MI (note: I can merge these together if needed)

Thanks -- Suzanne