1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| Range("AO1").Select
ActiveCell.FormulaR1C1 = "Format Ship By Date"
Range("AO2").Select
ActiveCell.FormulaR1C1 = "=IF(LEN(RC[-17])=16,0,1)"
Range("AO3").Select
Range("AP1").Select
ActiveCell.FormulaR1C1 = "SHIP BY MONTH" 'OLD SHIP BY DAY
Range("AP2").Select
ActiveCell.FormulaR1C1 = _
"=IFERROR(MID(RC[-18],SEARCH(""M"",RC[-18],1)-18,2),LEFT(TEXT(RC[-18],""MM""),10))"
Range("AP3").Select
Range("AQ1").Select
ActiveCell.FormulaR1C1 = "SHIP BY DAY" 'OLD SHIP BY MONTH
Range("AQ2").Select
ActiveCell.FormulaR1C1 = _
"=TEXT(IFERROR(MID(RC[-19],1,SEARCH(""/"",RC[-19],1)-1),LEFT(TEXT(RC[-19],""JJ""),10)),""00"")"
Range("AQ3").Select
Range("AR1").Select
ActiveCell.FormulaR1C1 = "SHIP BY YEAR"
Range("AR2").Select
ActiveCell.FormulaR1C1 = _
"=TEXT(IFERROR(MID(RC[-20],SEARCH("" "",RC[-20],1)-4,4),LEFT(TEXT(RC[-20],""AAAA""),10)),""00"")"
Range("AR3").Select
Range("AS1").Select
ActiveCell.FormulaR1C1 = "SHIP BY DATE"
Range("AS2").Select
ActiveCell.FormulaR1C1 = "=DATE(RC[-1],RC[-3],RC[-2])"
Range("AS3").Select
Range("AT1").Select
ActiveCell.FormulaR1C1 = "Format Due Date"
Range("AT2").Select
ActiveCell.FormulaR1C1 = "=IF(LEN(RC[-24])=16,0,1)"
Range("AT3").Select
Range("AU1").Select
ActiveCell.FormulaR1C1 = "DUE MONTH" 'OLD DUE DAY
Range("AU2").Select
ActiveCell.FormulaR1C1 = _
"=IFERROR(MID(RC[-25],SEARCH(""M"",RC[-25],1)-18,2),LEFT(TEXT(RC[-25],""MM""),10))"
Range("AU3").Select
Range("AV1").Select
ActiveCell.FormulaR1C1 = "DUE DAY" 'OLD DUE MONTH
Range("AV2").Select
ActiveCell.FormulaR1C1 = _
"=TEXT(IFERROR(MID(RC[-26],1,SEARCH(""/"",RC[-26],1)-1),LEFT(TEXT(RC[-26],""JJ""),10)),""00"")"
Range("AV3").Select
Range("AW1").Select
ActiveCell.FormulaR1C1 = "DUE YEAR"
Range("AW2").Select
ActiveCell.FormulaR1C1 = _
"=TEXT(IFERROR(MID(RC[-27],SEARCH("" "",RC[-27],1)-4,4),LEFT(TEXT(RC[-27],""AAAA""),10)),""00"")"
Range("AW3").Select
Range("AX1").Select
ActiveCell.FormulaR1C1 = "DUE DATE"
Range("AX2").Select
ActiveCell.FormulaR1C1 = "=DATE(RC[-1],RC[-3],RC[-2])"
Range("AX3").Select |
Partager