I need to develop by weekly time cards. Each employee has a folder that has their time cards in it. Each employee can work on several different jobs in a day and be doing several different tasks on one job or do several tasks on one job. The job list needs to updated about every other day. I would like to be able to have a master list of employee names, and job list, task list that when then employee opens heir time card it automatically updates the job list that is updated in a different folder than their timesheet. It would be nice if I could have a drop down that they could choose their name, job they worked on and the task they preformed.
I'm not sure what is the best functions to use. I have a drop down by weekly time sheet they are using now but I can't get it to use the updated job list.
Thank you in advance for your time.
I'm not sure what is the best functions to use. I have a drop down by weekly time sheet they are using now but I can't get it to use the updated job list.
Thank you in advance for your time.