Drop Down List For Schedule

[desnyder2001]

I am an extreme novice with Excel (Other than basic functions).

I am in the military and run Military Police section that I schedule 3 shifts (Days / Swings / Midnight).

I have developed an Excel spreadsheet to keep track of the schedule. I am trying to create a drop down list to select the person who will be working the shift.

The range of the row I am selecting is several columns long.

I would like to add 70+ workers and be able to select the the row of the worker I am assigning to the shift.
If you look at the spreadsheet this may make more sense.

I have lost many nights sleep over this and any help would be appreciated.

Thanks in advance for any help

[NeedForExcel]

Hey!

Please see the file attached.

It wasnt clearly mentioned in your post where you would like to place the Drop Down and the was slightly unclear of your requirement, so Iv put the Drop Down List where I found suitable. Kindly change as required.

Hope this is what was required.

Deep

[desnyder2001]

Ok, I guess I am not as smart as you would think.... I can't see where you added a drop down box.
In Column A where the names are listed is where I would like the drop down list. So as an example at A15 where is has additional posting is where I would like to click and be able to select a name for the additional posting. It would then populate row 15 with A15 through AT15.

Does this explain it any better?

[desnyder2001]

Ok, I just found where you added the drop down.
Sorry I was not more clear on what I was looking for.

I hope my last explanation helps.

Thanks for what you have already provided.

[NeedForExcel]

But is the content that is coming in the Drop Down List OK for you?

[desnyder2001]

Your drop down included the "name", I need the whole row inserted.
Let me try to give you more detail.
As you can see from the spreadsheet I have three different groups. Alpha Flight is my day shift. Bravo Flight is my Swing shift and Charlie Flight is my midnight shift.

I have eight full time people for each shift. Then I have a total of about 75 people that I can have fill in for each shift.

When I get someone to fill in for that shift, I would like to select them from the drop down list which will populate the whole row.

Like.

NAME * STATUS * CERT* SEP1ST * SEP2ND all the way through the end of the month

Sorry I am not real good at explaining this.

I really appreciate your help.

[NeedForExcel]

Hey!

Please find attached the new file.. See if it helps.

Deep

[desnyder2001]

NICE....

So how to I edit the list so I can add all 70+ of our people?

Wow, this is going to be so helpful

[NeedForExcel]

Hey!

If you go to Cell A499 you will see the formula I put. Copy it for 70+ Rows as required. I also have a Name assigned to it which you might need to change.

See if it helps.

Deep

[desnyder2001]

Ok we are very close.
First of all when I go to the list at a499, it has formulas, I am not sure how I am suppose to add names.
Next when it populates the row, it also uses formulas. I need to be able to change what position they are working under that day.

So as an example lets us SMSgt Snyder
Col A would be the name
Col B would be his status this could be a couple different things. (AGR / SAD / DSG / TT / TAGR)
Col C would be what his certifications are (FC / ESRT / W / ISRT / A)
Starting with Col D would be what position SMSgt Snyder is working on that given day
Example
X is his day off
Z-1 is supervisor
W is Desk Sergeant
and many others.

Under each day, I total the number of people available for working, each time I add a position to someone it calculates how many people are assigned that day. I have several conditional formatting for each position.

See attached spreadsheet.

[NeedForExcel]

The Formula is such that when you add names in Column A in SEP 2013 Sheet, the formulas will update automatically..