I found something I would like for my workbook. I found it on MVP Debra
Dalgleish's page http://www.contextures.com/xlDataVal03.html. The original
code is from Peo Sojblom and it's about hiding previously used items in a
drop down box. I have my list of dealers on a sheet (GamesDealt):

Col A is a list of Dealers (casino type).
col B is their hire date.
From Col C thru I has headings of: BJ PG WH TCP BS MB CR (games we offer)
I have an "X" in the row under the colunm of what game(s) they deal. Most
dealers deal more than one game.
If you put an "X" in the cell for what game they deal it copies their name
from Col A to Col L - R with the same headings as Col C thru I. - So if they
deal a game, x under what game they deal and it copies A1 to another set of
columns. The columns L-R are for the dynamic ranges for each game. I did this
due to high turnover rate of dealers (sucky job). I need to be able to add or
subtract dealers from Col A.
I did this because I have another sheet called "Monday" actually 7 of them 1
for each day of the week. It looks like A3 "BJ9" B3 is a data validation cell
and there are 17 of them (one for each game).

I want 17 drop boxes on sheet "Monday", each with a list of only the dealers
that deal that game, and once I use that person on a game, I don't want to be
able to pick them for another game on that same sheet. Hence Debra's page.

(Refer to Columns L-R, Those columns are dynamic named ranges.)

Peo's formulas a

array formula to make blank cells move to the bottom of the list
IF(ROW(A1:A6)-ROW(A1)+1COUNT(B1:B6),"",INDEX(A:A,SMALL(B1:B6,RO W(INDIRECT("1:"&ROWS(A1:A6)))))) <not my cell ranges

and to make sure each name is used once,
IF(COUNTIF(Schedule!$B$2:$B$7,A1)=1,"",ROW()) <not my ranges
I just can't make it work on my pages. - Can anyone point me in the right
direction. I have the formulas from her site, I just can't make it work on my
page.


How can I fit this to my needs?

Thanks in advance.

Robb