Sorry I misspelled your name Peo. Thanks for being here.

Robb

"Peo Sjobom" wrote:

Nice, now I don't have to do it. I felt for a moment it was my post to
answer but the misspelling of my name held me back <g

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Debra Dalgleish" wrote in message
...
I just added a sample file that may help you set up the weekday sheets:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "Assign Qualified Employees to Single Task
per Day"

Robb27 wrote:
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







--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html