The real amazing thing about that guy's name is the way he pronounces it:

Tom Smith





Debra Dalgleish wrote:

You're welcome, and thanks for letting me know that the sample file helped.
I'm sure Poe Sojolbloom wasn't really upset about the misspelling, and
thanks for getting my name right!

Robb27 wrote:
Thanks Debra, the new example on your page helped. Sometimes it takes a
different look at things.
I had to post an appology to Peo for butchering his name! lol

Robb

"Debra Dalgleish" wrote:


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

--

Dave Peterson