I need help with the attached file. I have 4 sheets in this file, the first sheet is for the entries, the second and third is the data for my list, employee and works, and the last sheet is the sample report.
This workbook is all about the job(s) an employee has done during the week. He can do 2 or more works in a day (refer to sheet 2) but the total works should not exceed the maximum hours required. Maximum hours can vary depending on the season, maximum hours during these months is 9 hours. I created list for the employee and works, is it possible that after I finished entering the data for one person, the employee list will automatically move to the next the record? I'm just wondering if this can be done in excel so as not to select it one by one. Also, in this entry sheet, another file will be updated to generate the report (sheet 4).
Any help or suggestions is most welcome.
Thanks in advance.
Bookmarks