Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Daily schedule to new worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Daily schedule to new worksheet
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Daily schedule to new worksheet
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 -- Dave CCMC Fort Worth, TX "ShaneDevenshire" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Daily schedule to new worksheet
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 -- Dave CCMC Fort Worth, TX "Dave76082" wrote: 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 -- Dave CCMC Fort Worth, TX "ShaneDevenshire" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
daily schedule-planner | Excel Discussion (Misc queries) | |||
daily work schedule hours calculation | Excel Discussion (Misc queries) | |||
Daily Schedule | Excel Discussion (Misc queries) | |||
Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
How do I use military time for daily schedule of appointments | Excel Discussion (Misc queries) |