Hi,

You could write a vba program to do it, but its not clear if each room is in
a separate column or in one cell to the right of a service. This would also
be an issue for a formula approach.

You might want to look at a pivot table, then you could filter on service
and show only the rooms for that service. Rooms in the column area and data
area, Service in the row area.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"NICK" wrote:

"NICK" wrote:

I need to produce a list by sevice owner(column b) that will print all the
rooms(column a) that fall under each service. please see below
i.e. Service
EMS 10002A,1002B,10010A.......
Psychiatry 10002,10009, 10010, 10014........



ROOM SERVICE OWNER SECT
10002 PSYCHIATRY NURSING STATION
10002A EMS TOILET
10002B EMS TOILET
10009 PSYCHIATRY DINING RM
10010 PSYCHIATRY BREAK RM
10010A EMS TOILET
10014 PSYCHIATRY GROUP RM
10101 PSYCHIATRY LOCKER RM
10020 PSYCHIATRY GROUP RM
10020A RECREATION STORAGE
10100 PSYCHIATRY MUSIC RM
10101 PSYCHIATRY LOCKER RM
10102 PSYCHIATRY CONFERENCE RM
10103 PSYCHIATRY GROUP RM
10104 PRIMARY CARE/NURISNG OFFICE
10105 PSYCHIATRY TESTING ROOM
10106 REHAB RESTORATIVE CARE SERVICE STORAGE
10107 ENGINEER CLOSET TELEPHONE
10108 EMS STAIRS


--
Thanks, Nick