Expanding a Legend

Question:

I work for a non-profit and I am updating a form we use at the office. The form is done in excel, and has a legend at the bottom of it. Although I like the way the form is set up, I did not create the form and now am trying to go in and improve it. The bottom part has a legend, and the legend has room for 10 names. The main form has times down the left hand side in ˝ hour increments, and days of the week at the top. The legend is set up with Busy, Available, and in addition a list of names the person works with. So I can go to 8:30am on Monday and type in busy (or Available), tab to the next spot, and the form will automatically highlight this according to what color “Busy” (or Available) is highlighted in the legend and counts it as 0 hours for a running total at the bottom. If I put in a person’s name it highlights the color that person is highlighted in the legend, and ˝ hour is added to the running total at the bottom of the sheet.

What I am trying to do is increase the Legend so that instead of holding 10 names it holds 90+ names, and I will highlight each with a different color and each will have a value of ˝ hour if put in a time slot, thus listing all clients on one template instead of having to tailoring the worksheet to each employee. The form does do this now, I just need to expand the legend part of it. Feel free to email me if you want to see the form I am working from.

Thanks
Walt

Here is the copy of the spreadsheet