Philip_Platt
New Member
- Joined
- Aug 7, 2007
- Messages
- 7
I have the following worksheet that keeps record of daily coatings usage at a conduit plant.
What I am wanting to do is create a userform that will allow a technician to enter the number of gallons of each coating that was used each day. I want to have a simple blank beside the name of each coating for the entering of the data and just have the person hit "enter" to submit the data to the worksheet.
The dates on the worksheet extend out to column AG (which hold 8/31).
At the end of each month, i want a new worksheet created in which it will start recording data for the new month. It should automatically name the sheet according the the month... ex: August 2007 --> Aug 07 etc...
I would also like for it to format in the same way as the previous month
Thanks,
Philip Platt
Book1.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
4 | MonthlyTotal(Gallons) | 8/1 | 8/2 | |||
5 | ANSIGray | 0 | ||||
6 | ASIBlue | 0 | ||||
7 | BallardGray | 0 | ||||
8 | Black | 0 | ||||
9 | Black(WaterBased) | 0 | ||||
10 | BrammerGray | 0 | ||||
11 | ChromeAluminum | 0 | ||||
12 | DesertTan | 0 | ||||
13 | EpoxyPnenicon | 0 | ||||
14 | EXXONGreen | 0 | ||||
15 | ForestGreen | 0 | ||||
16 | ForestGreen(WaterBased) | 0 | ||||
17 | GrayPrimer | 0 | ||||
18 | CoalTar | 0 | ||||
19 | IndustrialThinner(Toluene) | 0 | ||||
20 | Latte | 0 | ||||
21 | MethylEthylKetone(MEK) | 0 | ||||
22 | No-HAPSThinner | 0 | ||||
23 | PalletTan | 0 | ||||
24 | PermianBattleshipGray | 0 | ||||
25 | PermianBattleshipGray(WaterBased) | 0 | ||||
26 | RedOxidePrimer | 0 | ||||
27 | RedOxidePrimer(WaterBased) | 0 | ||||
28 | RustResistantAluminum | 0 | ||||
29 | SafetyBlue | 0 | ||||
30 | Sandstone | 0 | ||||
31 | Sandstone(WaterBased) | 0 | ||||
32 | ShaleBlue | 0 | ||||
33 | SonatGray | 0 | ||||
34 | SonatGray(WaterBased) | 0 | ||||
35 | StructuralGray | 0 | ||||
36 | SyntheticThinner | 0 | ||||
37 | White | 0 | ||||
38 | White(WaterBased) | 0 | ||||
39 | WhitePolyurethane | 0 | ||||
40 | WhitePrimer | 0 | ||||
41 | Xylene | 0 | ||||
42 | ZincClad | 0 | ||||
43 | ZincPrimer | 0 | ||||
Aug 2007 |
What I am wanting to do is create a userform that will allow a technician to enter the number of gallons of each coating that was used each day. I want to have a simple blank beside the name of each coating for the entering of the data and just have the person hit "enter" to submit the data to the worksheet.
The dates on the worksheet extend out to column AG (which hold 8/31).
At the end of each month, i want a new worksheet created in which it will start recording data for the new month. It should automatically name the sheet according the the month... ex: August 2007 --> Aug 07 etc...
I would also like for it to format in the same way as the previous month
Thanks,
Philip Platt