Spreadsheet: 47624d1246713939-auto-copy-from-1-sheet-to-other-if-condition-met-invoicecreator
Sheet: Items

 | Ordering Sheet
 | Product Code | Item Description | QTY | Price | Total | Dept
1 | 230001 | Product #1 | 14 | 1.25 | 17.5 | HR
 | 230002 | Product #2 |  | 2.5 | 0 | HR
 | 230003 | Product #3 |  | 3.4 | 0 | HR
 | 230004 | Product #4 |  | 1.4 | 0 | HR
 | 230005 | Product #5 |  | 4 | 0 | HR
2 | 230006 | Product #6 | 7 | 1.4 | 9.799999999999999 | HR
 | 230007 | Product #7 |  | 2.7 | 0 | HR
 | 230008 | Product #8 |  | 3 | 0 | HR
 | 230009 | Product #9 |  | 2.8 | 0 | HR
 | 230010 | Product #10 |  | 4.25 | 0 | Appl
3 | 230011 | Product #11 | 12 | 1.8 | 21.6 | Appl
 | 230012 | Product #12 |  | 3.25 | 0 | Appl
 | 230013 | Product #13 |  | 1.8 | 0 | Appl
 | 230014 | Product #14 |  | 4.75 | 0 | Appl
 | 230015 | Product #15 |  | 3.9 | 0 | Appl
4 | 230016 | Product #16 | 3 | 2.25 | 6.75 | Appl
 | 230017 | Product #17 |  | 5 | 0 | Appl
 | 230018 | Product #18 |  | 1.65 | 0 | Appl
 | 230019 | Product #19 |  | 3 | 0 | Appl
 | 230020 | Product #20 |  | 2.4 | 0 | Appl
 | 230021 | Product #21 |  | 1.25 | 0 | Appl
 | 230022 | Product #22 |  | 2.5 | 0 | Int
 | 230023 | Product #23 |  | 3.4 | 0 | Int
 | 230024 | Product #24 |  | 1.4 | 0 | Int
 | 230025 | Product #25 |  | 4 | 0 | Int
 | 230026 | Product #26 |  | 1.4 | 0 | Int
 | 230027 | Product #27 |  | 2.7 | 0 | Int
5 | 230028 | Product #28 | 16 | 3 | 48 | Int
 | 230029 | Product #29 |  | 2.8 | 0 | Int
 | 230030 | Product #30 |  | 4.25 | 0 | Int
 | 230031 | Product #31 |  | 1.8 | 0 | Int
 | 230032 | Product #32 |  | 3.25 | 0 | Int
 | 230033 | Product #33 |  | 1.8 | 0 | Int
 | 230034 | Product #34 |  | 4.75 | 0 | Int
 | 230035 | Product #35 |  | 3.9 | 0 | Int
 | 230036 | Product #36 |  | 2.25 | 0 | Int
 | 230037 | Product #37 |  | 5 | 0 | Int
 | 230038 | Product #38 |  | 1.65 | 0 | Int
 | 230039 | Product #39 |  | 3 | 0 | Ext
 | 230040 | Product #40 |  | 2.4 | 0 | Ext
 | 230041 | Product #41 |  | 1.25 | 0 | Ext
 | 230042 | Product #42 |  | 2.5 | 0 | Ext
 | 230043 | Product #43 |  | 3.4 | 0 | Ext
 | 230044 | Product #44 |  | 1.4 | 0 | Ext
 | 230045 | Product #45 |  | 4 | 0 | Ext
 | 230046 | Product #46 |  | 1.4 | 0 | Ext
 | 230047 | Product #47 |  | 2.7 | 0 | Ext
 | 230048 | Product #48 |  | 3 | 0 | Ext
 | 230049 | Product #49 |  | 2.8 | 0 | Ext
 | 230050 | Product #50 |  | 4.25 | 0 | Ext
 | 230051 | Product #51 |  | 1.8 | 0 | Ext
 | 230052 | Product #52 |  | 3.25 | 0 | Ext
 | 230053 | Product #53 |  | 1.8 | 0 | Ext
 | 230054 | Product #54 |  | 4.75 | 0 | Ext
 | 230055 | Product #55 |  | 3.9 | 0 | Ext
 | 230056 | Product #56 |  | 2.25 | 0 | Ext
 | 230057 | Product #57 |  | 5 | 0 | Grdn
 | 230058 | Product #58 |  | 1.65 | 0 | Grdn
 | 230059 | Product #59 |  | 3 | 0 | Grdn
 | 230060 | Product #60 |  | 2.4 | 0 | Grdn
 | 230061 | Product #61 |  | 1.25 | 0 | Grdn
 | 230062 | Product #62 |  | 2.5 | 0 | Grdn
 | 230063 | Product #63 |  | 3.4 | 0 | Grdn
 | 230064 | Product #64 |  | 1.4 | 0 | Grdn
 | 230065 | Product #65 |  | 4 | 0 | Grdn
 | 230066 | Product #66 |  | 1.4 | 0 | Grdn
 | 230067 | Product #67 |  | 2.7 | 0 | Grdn
 | 230068 | Product #68 |  | 3 | 0 | Grdn
 | 230069 | Product #69 |  | 2.8 | 0 | Grdn
 | 230070 | Product #70 |  | 4.25 | 0 | Grdn
 | 230071 | Product #71 |  | 1.8 | 0 | Grdn
 | 230072 | Product #72 |  | 3.25 | 0 | Grdn
 | 230073 | Product #73 |  | 1.8 | 0 | Grdn
 | 230074 | Product #74 |  | 4.75 | 0 | Grdn
 | 230075 | Product #75 |  | 3.9 | 0 | Grdn
 | 230076 | Product #76 |  | 2.25 | 0 | Grdn
 | 230077 | Product #77 |  | 5 | 0 | Grdn
 | 230078 | Product #78 |  | 1.65 | 0 | Grdn
 | 230079 | Product #79 |  | 3 | 0 | Grdn
 | 230080 | Product #80 |  | 2.4 | 0 | Grdn
 | 230081 | Product #81 |  | 3 | 0 | Grdn
 | 230082 | Product #82 |  | 2.4 | 0 | Grdn
 | 230083 | Product #83 |  | 1.25 | 0 | Grdn
 | 230084 | Product #84 |  | 2.5 | 0 | Grdn
 | 230085 | Product #85 |  | 3.4 | 0 | Grdn
 | 230086 | Product #86 |  | 1.4 | 0 | Grdn
 | 230087 | Product #87 |  | 4 | 0 | Grdn
 | 230088 | Product #88 |  | 1.4 | 0 | Grdn
 | 230089 | Product #89 |  | 2.7 | 0 | Grdn
 | 230090 | Product #90 |  | 3 | 0 | Grdn
 | 230091 | Product #91 |  | 2.8 | 0 | Grdn
 | 230092 | Product #92 |  | 4.25 | 0 | Grdn
 | 230093 | Product #93 |  | 1.8 | 0 | Grdn
 | 230094 | Product #94 |  | 3.25 | 0 | Grdn
 | 230095 | Product #95 |  | 1.8 | 0 | Grdn
 | 230096 | Product #96 |  | 4.75 | 0 | Grdn