I have a file I use to report weekly work orders for several regions and accounts. It works great, but is a bit tedious and I have to remember to copy/paste as values (on two tabs) before sending out.
Would there be any benefit to having these as a VBA marco?
Would there be any benefit to having these as a VBA marco?
date | =IFERROR(IF(P4="Dispatch",TEXT(TRIM(LEFT(D4,10)),"m/d/yyyy"),TEXT(MID(P4,FIND(" ",P4,FIND(" ",P4)+1)+1,256),"m/d/yyyy")),TEXT(TRIM(LEFT(D4,10)),"m/d/yyyy")) |
days | =TODAY()-U4 |
Type | =IFERROR(IF(ISNUMBER(SEARCH("SM",P4)),"SM",IF(AND(P4="Dispatch",ISNUMBER(SEARCH("Incoming Inspection",Q4))),"Incoming","DM")),"DM") |
DM | =INDEX(Act.Summary!$B$4:$D$61,MATCH(G4,Act.Summary!$B$4:$B$61,),2) |
AM | =INDEX(Act.Summary!$B$4:$D$61,MATCH(G4,Act.Summary!$B$4:$B$61,),3) |