The easiest way would be to have your list of 3,000 names in a column
and the list of 30 staff names in a row along the top of the same sheet.
If you format the staff names so the text is on its side and make the
columns narrow all 30 staff will fit on one screen width.

So, cells B1:AE1 will contain staff names and will be formatted so the
text is on the side and will be narrow columns. Cells A2:A3001 will
contain the 3000 names and will be wide enough to show all names
(use auto fit). Go to cell B2 and freeze panes (menu Window -- Freeze
Panes).

Each staff puts an X in any cell in their column for anyone whom they
wish to give a card to.

Hope this helps.

Chrissy.

"colinmunnelly" wrote in message ...
yes i need to find out from all the 30 staff who they would like to send
an xmas card to from the 3000 list of names



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/