C
Cel
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.
+-------------------------------------------------------------------+
|Filename: work control.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5073 |
+-------------------------------------------------------------------+
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.
+-------------------------------------------------------------------+
|Filename: work control.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5073 |
+-------------------------------------------------------------------+