Here's what I want to do
I have a senority list. Depending on senority there a different number of
vacations. There also limits to vacations per day. Like 8 people can be off
on June 7th. How can I input the persons choice in a cell by there name, and
at the same time enter there information on June 7. It has space for 8 people
like this

Name , Days , Pick 1 , Pick 2, Pick 3
Joe Blow , 3 days vac , June 7 , Nov 11, August 6
Mike Slo , 4 days vac, June 7, Feb 12 , Dec 25


Enters into chart

June 7 , ...., August 6, ..., Nov 11,......., Dec 25
Joe Blow Joe Blow Joe Blow
Mike Slo Mike slo

I know this is kind of abstract but it's the only way I can relate what I
want to do

Suggest this:

Color the fonts with senority/vacation indicators (i.e. blue font = 3 weeks,
red = 2 weeks, etc. - Joe Blow is blue, XXXX is red, etc. I would put their
names in column A. In column B put the beginning date of vacation time (i.e.
1/2/07, and draw it across. You'll probably only want to show workdays, not
weekends. At the bottom of the list, enter =counta(B2:B (put your last row
here), and draw it across. Each time you put a number(pick 1,2, etc) in the
date for vacation requested, the bottom line will total all the occurrences
of the number. If it is greater than 8, you'll know!

Hope this helps,

Carole O

"Marty" wrote:

Here's what I want to do
I have a senority list. Depending on senority there a different number of
vacations. There also limits to vacations per day. Like 8 people can be off
on June 7th. How can I input the persons choice in a cell by there name, and
at the same time enter there information on June 7. It has space for 8 people
like this

Name , Days , Pick 1 , Pick 2, Pick 3
Joe Blow , 3 days vac , June 7 , Nov 11, August 6
Mike Slo , 4 days vac, June 7, Feb 12 , Dec 25


Enters into chart

June 7 , ...., August 6, ..., Nov 11,......., Dec 25
Joe Blow Joe Blow Joe Blow
Mike Slo Mike slo

I know this is kind of abstract but it's the only way I can relate what I
want to do