Prem Tourani
New Member
i am very weak on the macros and need help on it for the attached workbook. It is time sheet workbook, where the employee will be entering the details about the date, which project they have worked and time spent on the project (“Weekly report”). The second work sheet gives me the project wise breakup on each day for the month. The third sheet gives me the weekly break up (percentagewise).
I need a macro where in if the employee has not worked on any weekly off then the macro should fetch the data from Weekwise report and post it “weekly report” in the first available blank row, based on which week that week-off is on. The data that needs to be posted on the weekly report is first the date followed by “project Number” to “Project No.” then “From No.” to “From hr.” then “Break” to “break” and “to No.” to “to hr.” and should post “Weekly off” in “task description”. It will show on “Project wise sheet” on which weekoff the employee has not worked.
Attached is a sample file with data.
Regards,
Prem Tourani.
I need a macro where in if the employee has not worked on any weekly off then the macro should fetch the data from Weekwise report and post it “weekly report” in the first available blank row, based on which week that week-off is on. The data that needs to be posted on the weekly report is first the date followed by “project Number” to “Project No.” then “From No.” to “From hr.” then “Break” to “break” and “to No.” to “to hr.” and should post “Weekly off” in “task description”. It will show on “Project wise sheet” on which weekoff the employee has not worked.
Attached is a sample file with data.
Regards,
Prem Tourani.