Dear Experts
my Aim is to find out how many man hours is spent in each project and cost of manpower. with the reference of Job number
1. On each new projects. Job details and Client details are entered in (WS)Projects. and new Job Number (Job#) is created manually
2. Then Job sheet is prepared and the jobs are assigned to the list of Employees everyday.
3. At end of the day, daily report is collected from the supervisor and added to the Job number
4. Process Starts here at (WS) DailyTaskEntry > Date, Job#, Location, Hours and Note is entered under each fixed employee's name. and Added
(Employee name will always be there in DailyTaskEntry worksheet)
5. This informations have to be stored some where with reference of Job # and date.
5. Later, if any changes on the above stored informations, then the data must be retrieved, using date search > Edit and then saved back to the same Job#.
(after retrieving, "Add " button must be changed to "save changes" button)
7. Lastly as a result - (ws) Job Sheet, upon the selection(query) of Job number, details like Date wise, Employee name who worked for this particular job, Hrs, Location and Notes have to displayed. (As show in ws. Job Sheet)
Note: kindly refer the attachment NewJS.xlsx
Hope my explanation will make you understand the activities involved.
Thank you so much for your time.
-sk
Bookmarks