I've been given the job of posting a schedule of personnel available to work
on a specific day. Short of creating up to 31 individual macros and assigning
them to each cell (above the date and creating a button for it)) is there a
way of extracting this info and posting it to sheet 2 of the workbook? i.e.
the personnel available and their assignment. This would have to be available
for up to 50 people. Data in the original schedule is formatted as follows:

Employee 1 2 3 4
Sun Mon Tue Wed
Amy D10 D1 D11
Barb T1 T4 T3
Cathy D9 D2 D1
Dianne T3 C
Emily ADM X D
Frances V V V
Gina D8 D3 D2
Harriet D S S V
Irene P X P
Janice V V V

I'm probably trying to make this way to complicated, but just can't seem to
figure it out. Thanks in advance
--
Dave
CCMC Fort Worth, TX