ok..i'm in over my head on this one.
3 sheets in the workbook
Employee
Manages
Data
Data sheet contains a list of employee names, a list of possible schedule time (11-5,1-9,6-CL), and a list of possible positions. All data is directly enter on this sheet.
Employee sheet is the master employee schedule (ALL information on this page come from data validation list from the data page..everything here is drop down list) ..Column A is employee name, Column B is scheduled shift (5-11..etc), Column C is AM or PM, Column D is position (Driver or In shop)
Managers sheet is the managers schedule. 7 columns...one for each day of the week. In each column you have a section for Inshop AM, Driver AM, Inshop Pm, Driver Pm. 7 columns...4 sections to each column. No data should be selected or entered on this page it should automatily come from the choices made on the employee sheet. Under each section the only thing that needs to appear is a name (no shift or am/pm)...based in the column criteria (IE...if the person is scheduled for AM inshop or PM Driver..etc)
My issue is this... I need to have the managers sheet automatically populate with data as it is changed/entered on the employee sheet. As I select Job Brown on the employee sheet for a position as a PM driver on Sunday he needs to appear in the section for PM Drivers on Sunday. The problem I'm having is I criteria in multiple columns and I really don't know how to deal with it correctly...how to meet conditions in multiple columns and then copy data from yet another column.
Confused yet?? I am.
Comments / questions (god knows I surely left somethings out!) / suggestions?
Bookmarks