Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Weekly Schedule, help create form
I'm new to excel but I have learned a lot. I need help to improve my Excel Weekly Work Order Schedule. I need to make a FORM to fill out the Work orders for each day of the week. I receive the orders with various due dates so I have to scroll up and down to much to input all the information. I would like a form for Day ,Hours and Minutes. I need the days of the week to stay in there current cells. Here's how I have it so far. A1 has Monday's date. I use this cell to auto fill in the dates for Monday to Friday. A2 =TEXT(A1,"ddd mm / dd") A3 to A20 I use to manually type in the customers name. B2 Hrs This is just to label this column B3 to B20 I type in the Hours work. C2 Min This is to label this column . C3 to C20 I type in the Minutes worked D2 X This is to label this column. D3 to D20 I type in an X when work is completed. D21 Total Hours this is a label. Column E I use as a Spacer to separate the days Now copy all cells A2 to D21 to Cells F2 to I21 I won’t repeat all of it to save time. Change F2 to show the correct date. F2 =TEXT(A1+(1),"ddd mm / dd") F3 to F20 I use to manually type in the customers name Copy A2 to D21 to A22 to D41 Change A22 to show correct date. A22 =TEXT(A1+(2),"ddd mm / dd") Copy A2 to D21 to F22 I41 Change for correct date =TEXT(A1+(3),"ddd mm / dd") Lastly Copy A2 D21 to A42 D61 Change for correct date. =TEXT(A1+(4),"ddd mm / dd") Thank you for your help. Steven -- StevenPar ------------------------------------------------------------------------ StevenPar's Profile: http://www.excelforum.com/member.php...o&userid=24641 View this thread: http://www.excelforum.com/showthread...hreadid=382284 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create an Employee weekly scheduler | Excel Worksheet Functions | |||
How do I create a form that can be filled in on the computer | Excel Discussion (Misc queries) | |||
Create form that can't be chg'd but info can be copied/pasted? | Excel Discussion (Misc queries) | |||
How do you create a vendor tracking form for accounts payable pro. | Excel Discussion (Misc queries) | |||
How do I create project schedule using excel - office 2000 | Excel Discussion (Misc queries) |