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