Spreadsheet: 741065d1626792184-help-with-brushing-up-formula-that-copies-row-data-automatically-from-another-sheet-gk-20-07-15-00
Sheet: Analysis

ORDER - PO | ORDER - STATUS: | STAFF - ORDER TAKEN BY: | STAFF - STOCK ORDERED BY: | STAFF - DELIVERY CHECKED BY: | STAFF - FLOORING INSTALLED BY: | FEEDBACK - CONTACT SOURCE: | FEEDBACK - REFERALL TYPE: | FEEDBACK - GDPR CONSENT: | FEEDBACK - OVERALL CUSTOMER SATISFACTION: | FEEDBACK - CUSTOMER FEEDBACK NOTES: | DATE - INPUTTED DATA: | DATE - INPUTTED DATA MONTH YEAR: | DATE - CUSTOMER ORDERED: | DATE - CUSTOMER ORDERED MONTH YEAR: | DATE - CUSTOMER INSTALLATION DATE: | DATE - CUSTOMER INSTALLATION DATE MONTH YEAR: | DATE - ORDERED WITH SUPPLIER: | DATE - SUPPLIER FINAL DELIVERY DATE: | SUPPLIER PAYMENT DUE DATE: | DATE - SUPPLIER INVOICE PAID: | CUSTOMER -  FULL NAME: | CUSTOMER - EMAIL: | CUSTOMER - PHONE: | CUSTOMER - ADDRESS (1ST LINE): | CUSTOMER - ADDRESS (CITY): | CUSTOMER - ADDRESS  (POST CODE): | CUSTOMER - DELIVERY ADDRESS (IF [NAME]): | PRODUCT 1 - CODE: | PRODUCT 1 - SIZE (SQM) | PRODUCT 1 - UNIT COST SQM (INC. VAT) | PRODUCT 1 - QTY | PRODUCT 1 - TOTAL COST | PRODUCT 2 - CODE: | PRODUCT 2 - SIZE (SQM) | PRODUCT 2 - UNIT COST (INC. VAT) | PRODUCT 2 - QTY | PRODUCT 2 - TOTAL COST | PRODUCT 3 - CODE: | PRODUCT 3 - SIZE (SQM) | PRODUCT 3 - UNIT COST (INC. VAT) | PRODUCT 3 - QTY | PRODUCT 3 - TOTAL COST (INC. VAT) | PRODUCT 4 - CODE: | PRODUCT 4 - SIZE (SQM) | PRODUCT 4 - UNIT COST (INC. VAT) | PRODUCT 4 - QTY | PRODUCT 4 - TOTAL COST (INC. VAT) | PRODUCT 5 - CODE: | PRODUCT 5 - SIZE (SQM) | PRODUCT 5 - UNIT COST (INC. VAT) | PRODUCT 5 - QTY | PRODUCT 5 - TOTAL COST | PAYMENT - TOTAL FLOORING COST | PAYMENT - TOTAL ACCESSORY COST | PAYMENT - TOTAL INSTALLATION COST | PAYMENT - TOTAL COST OF JOB: | PAYMENT - RRP | PAYMENT - FINAL QUOTE | PAYMENT - ORDER PROFIT | PAYMENT - PROFIT MARGIN: | PAYMENT TYPE | PAYMENT - CUSTOMER PAID: | PAYMENT - OUTSTANDING | PAYMENT -HAS INVOICE BEEN PAID: | NOTES: | No. Products ordered
 | 1. Return enquiry (phone call, email, dm) | Javed | 1. Javed | 1. Javed | 1. Majeed | 2. Online | 5. Word of [NAME] | Yes | Very Satisfied | Good price, quick installation, professional job and cleaned up after | 2021-07-02 00:00:00 |  | 2021-07-04 00:00:00 |  | 2021-07-06 00:00:00 |  | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-10 00:00:00 | 2021-07-11 00:00:00 | FAHAD | [EMAIL] | 77777777777 | 70 ST Michaelangelos Road | Bradford | BDD DDD |  | 4.FURLONGS. - CAREFREE TWIST - Blue - HALF ROLE | 1 |  | 3 |  | 5.FURLONGS. - CHARME - Green - HALF ROLE | 3 |  | 1 |  | 8.FURLONGS. - EMINENCE -  - HALF ROLE | 11 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2500 |  |  | 1.Card | 2500 |  |  | Pull up carpets, install carpets and and new treads
 | Q | W | E | R | T | Y | U | I | O | P | 2021-06-01 00:00:00 |  | 2021-06-03 00:00:00 |  | 2021-06-05 00:00:00 |  | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | QQ | WW | 123456 | EE | RRR | TT | YY | 6.FURLONGS. - DAKAR -  - HALF ROLE | 1 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 | 3. Done - Measurement | 3. Marion |  | 2. [NAME] |  |  |  |  |  |  | 2021-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.FURLONGS. - CAREFREE TWIST - Blue - HALF ROLE | 1 |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.FURLONGS. - ATLAS - Grey - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.FURLONGS. - ATLAS - Grey - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.FURLONGS. - CHARME - Green - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.FURLONGS. - DAKAR -  - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.FURLONGS. - CAREFREE TWIST - Blue - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.FURLONGS. - DAKAR -  - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.FURLONGS. - CHARME - Green - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.FURLONGS. - CHARME - Green - HALF ROLE | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.FURLONGS. - CHARME - Green - HALF ROLE | 1 |  | 111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.FURLONGS. - DAKAR -  - HALF ROLE | 1 |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.FURLONGS. - CHARME - Green - HALF ROLE | 1 |  | 1