Thank you forpromt response.
We have a spread sheet that a user enters data on when registering people.
Among other columns, the registrants name is entered into column B, and the
table he is assigned to is entered in column R.
There is another question answer process that determines which table he/she
gets assigned to. Once assigned, I want, on another sheet, a room layout
showing each numbered table. I want the names of all people assigned to ,say
table 11, to appear on the top of the table marked as 11.
On the registration spread sheet,The assignment to table 11 may be on one
row, and then several rows later, another person will be registered and
assigned to table 11. Up to 10 people can be assigned to one table.


"Frank Kabel" wrote:

Hi
how do you identify exactly who is assigned to a conference (post some
example rows)

One way would be to use the Advanced Filter feature (try the addin:
http://www.rondebruin.nl/easyfilter.htm)

--
Regards
Frank Kabel
Frankfurt, Germany
"Tucson Guy" schrieb im Newsbeitrag
...
Main worksheet has members name in Comumn B.
In column R is table he/she is assigned to at conference.
I need to extract names of all people who are assigned to ,say, table 11
and put them in another column, one after the other, with no blank rows .
Thanks for your help.