#### Earlyfreak

##### New Member

- Joined
- Jan 31, 2017

- Messages
- 16

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>