Hi,

I'm not sure I understand your data setup, but suppose you have the data
setup with

If you data was set up like this you could use a pivot table:

Name Date Hours
Shane 1/1/2008 8
....

But if your data is set up with dates across the top row and names down the
first column maybe just include all the date from left to right and under
each date for each person enter the appropriate info. The select all the
names in column A, along with the title and choose Data, Filter, AutoFilter.
Now you can pick anyone from the autofilter drop down as see their schedule.


--
Thanks,
Shane Devenshire


"Dave76082" wrote:

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