Add, Retrieve and Edit data

[skhari]

Hi Experts

Please help me. Adding, Retrieving and Editing Daily Task with the reference of relevant Job number and Date.
Kindly refer the attachment in which i have highlighted the requirement
Thank you so much for your time

-SK

[excelliot]

can you explain sequence of activities..

[skhari]

Thanks for listening

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

[excelliot]

Great, this make sense...

Let me check solution to it..

[excelliot]

One Qn, how many entry for a day for an employee will be there??

[skhari]

Yes!. Max an employee will have 3 task per day, which is 3 entry per day (in the same date) for each employee
Thank you for your concern.

Please refer attachment,something like that.

-sk