Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help in excel list
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 | +-------------------------------------------------------------------+ -- Cel ------------------------------------------------------------------------ Cel's Profile: http://www.excelforum.com/member.php...o&userid=36472 View this thread: http://www.excelforum.com/showthread...hreadid=563977 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel e-mail list to netscape | Excel Discussion (Misc queries) | |||
Excel 2003 list of field codes for footers? | Excel Discussion (Misc queries) | |||
Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) |