Earlyfreak
New Member
- Joined
- Jan 31, 2017
- Messages
- 16
I am looking for a direction to automate this manual intense process. I have different counts to do each week example
Week 5
53
Week 6
30
Week 7
51
Week 8
55
Week 9
51
Week 10
60
I am looking to take the week total and split it into 5 workdays to complete
The problem is each week is different. I manually split and process now.
I can do this with formula's that I know of
Is there a VBA solution?
Any direction would be greatly appriciated
Here is example data
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Week 5
53
Week 6
30
Week 7
51
Week 8
55
Week 9
51
Week 10
60
I am looking to take the week total and split it into 5 workdays to complete
The problem is each week is different. I manually split and process now.
I can do this with formula's that I know of
Is there a VBA solution?
Any direction would be greatly appriciated
Here is example data
Item | Description | Week # | Completion Date |
711 | N 50 GAL 40 BTU NAT GAS | Week 5 | May 19th |
710 | N 40 GAL 40 BTU NAT GAS | Week 5 | May 19th |
709 | N 40 GAL 40 BTU NAT GAS | Week 5 | May 19th |
706 | -1NCWW 50 GAL 240V | Week 5 | May 19th |
712 | N 48 GAL 40 BTU NAT GAS | Week 5 | May 19th |
691 | N 75 GAL 76 BTU NAT GAS | Week 5 | May 19th |
774 | S6N 50 GAL 40 BTU NAT GAS | Week 5 | May 19th |
702 | -1NCWW 40 GAL 240V | Week 5 | May 19th |
705 | -1NCWW 40 GAL 240V | Week 5 | May 19th |
557 | -1NCZZ 208V / 4500 | Week 5 | May 19th |
471 | 1NAL RESIDENTIAL ELECTRIC | Week 5 | May 19th |
728 | T6N 50 GAL 40 BTU NAT GAS | Week 5 | May 19th |
215 | 0N 50 GAL 40 BTU NAT 10YR | Week 5 | May 19th |
747 | H6N 75 GAL 76 BTU NAT GAS | Week 5 | May 19th |
703 | -1NCWW 50 GAL 240V | Week 5 | May 19th |
704 | -1NCWW 30 GAL 240V | Week 5 | May 19th |
690 | N 48 GAL 65 BTU NAT GAS | Week 5 | May 19th |
169 | 00 BW 240V-4500W STD ELMT | Week 5 | May 19th |
469 | -1NAL RESIDENTIAL | Week 5 | May 19th |
219 | 0N 40 GAL 40 BTU NAT 10YR | Week 5 | May 19th |
465 | -1NAL 10 GAL ELECT HEATER | Week 5 | May 19th |
759 | -1NCWW 38 GAL 240V | Week 5 | May 19th |
758 | -1NCWW 28 GAL 240V | Week 5 | May 19th |
892 | 0N 75 GAL 76 BTU NAT GAS | Week 5 | May 19th |
726 | T6N 40GAL 40 BTU NAT GAS | Week 5 | May 19th |
695 | 5H6N 75 GAL 80 BTU NAT | Week 5 | May 19th |
713 | S6N 40 GAL 40 BTU NAT GAS | Week 5 | May 19th |
732 | 0H6N 48 GAL 60 BTU NAT | Week 5 | May 19th |
767 | X 40 GAL 38 BTU LP GAS | Week 5 | May 19th |
760 | -1NCWW 47 GAL 240V | Week 5 | May 19th |
470 | -1NAL RESIDENTIAL ELECTR | Week 5 | May 19th |
812 | LVL 1 UPGRD HTR KIT | Week 5 | May 19th |
707 | N 30 GAL 32 BTU NAT GAS | Week 5 | May 19th |
765 | X 50 GAL 36 BTU LP GAS | Week 5 | May 19th |
298 | 01 BW KIT-NAT GAS VALVE | Week 5 | May 19th |
779 | T6X 50 GAL 40 BTU LP GAS | Week 5 | May 19th |
681 | R-L 40 GAL INDIRECT | Week 5 | May 19th |
764 | X 40 GAL 36 BTU LP GAS | Week 5 | May 19th |
895 | N 40 GAL 34 BTU NAT GAS | Week 5 | May 19th |
701 | N 50 GAL 50 BTU NAT GAS | Week 5 | May 19th |
777 | S6X 50 GAL 38 BTU LP GAS | Week 5 | May 19th |
292 | 00 BW VAPOR SENSOR | Week 5 | May 19th |
782 | H6X 75 GAL 75.5 BTU LP | Week 5 | May 19th |
734 | 00 BW VENT TERMINAL / | Week 5 | May 19th |
746 | 0S6N 50 GAL 40 BTU NAT | Week 5 | May 19th |
496 | 763N 75 GAL 76 BTU NAT | Week 5 | May 19th |
730 | H6N 48 GAL 65 BTU NAT GAS | Week 5 | May 19th |
313 | 05 BW PILOT-NAT 17/26 HON | Week 5 | May 19th |
220 | 0N 48 GAL 40 BTU NAT 10YR | Week 5 | May 19th |
693 | 00 UPPER&LOWER T STAT | Week 5 | May 19th |
221 | T 10GAL 240V/4KW 208V/3KW | Week 5 | May 19th |
680 | R-L 50 GAL INDIRECT | Week 5 | May 19th |
734 | 0S6N 40 GAL 40 BTU NAT | Week 5 | May 19th |
864 | V PILOT *** Y 190 NAT RK | Week 6 | May 26th |
958 | TI-540H NG TANKLESS HTR | Week 6 | May 26th |
692 | 6005 KIT PILOT WITH | Week 6 | May 26th |
696 | 4005 KIT GAS CONTROL | Week 6 | May 26th |
53 | TUBING 560-742-860 | Week 6 | May 26th |
541 | 631 NEUTRALIZER KIT | Week 6 | May 26th |
89 | C THERM ROLLOUT SWITCH | Week 6 | May 26th |
544 | 620 MAINTENANCE KIT F/ | Week 6 | May 26th |
379 | ON ELECTRODE KIT F/ULTRA | Week 6 | May 26th |
14 | SWITCH 24V 510-300-013 | Week 6 | May 26th |
90 | ASSY W/CABLE 511-330-218 | Week 6 | May 26th |
131 | TRIM EG-PIDN 381-800-837 | Week 6 | May 26th |
836 | N CGA-4-PIDN GAS BLR 2012 | Week 6 | May 26th |
837 | N CGA-5-PIDN GAS BLR 2012 | Week 6 | May 26th |
893 | N EG30-50 GAS CTRL 2012 | Week 6 | May 26th |
542 | 630 ULTRA P/T GAUGE | Week 6 | May 26th |
32 | ECKETT BURNER | Week 6 | May 26th |
27 | ERMOSTAT RES 633-900-130 | Week 6 | May 26th |
898 | N EG40-45 JACKET 2012 | Week 6 | May 26th |
58 | HOOD EG-45 450-021-258 | Week 6 | May 26th |
55 | HOOD EG-40 450-021-257 | Week 6 | May 26th |
24 | R KIT 511-330-148 | Week 6 | May 26th |
946 | 0-020 THERMOSTAT RPR KIT | Week 6 | May 26th |
39 | N ASSY EG 40-45 | Week 6 | May 26th |
56 | N RELAY 24V 510-350-223 | Week 6 | May 26th |
888 | N EG45 BASE ASSY 2012 | Week 6 | May 26th |
172 | 0-658 U-CONTROL F/ULTRA | Week 6 | May 26th |
65 | RELAY W/RECP. 510-312-166 | Week 6 | May 26th |
33 | ECKETT BURNER | Week 6 | May 26th |
835 | N CGA-3PIDN GAS BLR 2012 | Week 6 | May 26th |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>