Daily schedule to new worksheet

D

Dave76082

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
 
S

ShaneDevenshire

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.
 
D

Dave76082

Hi Shane, and thanks for your quick response, unfortunately, I couldn't get
to the computer yesterday. My data is more like your second example: names
down the first column, dates of the month across the top, and shifts worked
populating the cells. All I want to do is be able to do is have some sort of
way to enter the date of the month and get a list of all people working that
day, and the shifts they are working. A simple 2 column output would be just
fine. Would a pivot table still be able to do this, or would it be easier to
export the whole schedule into an Access dastabase and do some 'find'
functions.
Again thanks for your help and patience.

Dave
 
D

Dave76082

Shane, I did finally get something worked out using the pivot table and it
gives me the results I need, but I still have one question... I was told
today that they want the shifts sorted in a particular order with certain
shifts at the top of the column (instead of personnel in alphabetical order),
certain ones next and so forth. I can't seem to get the results in the pivot
table to sort no matter what I try. I would need to do a custom sort to
accomplish this. Any ideas??
Thanks again

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top