Spreadsheet: 170317d1343234805-advice-macros-or-formulas-online-example-parts
Sheet: online example parts

 |  | Sales
 | Item Number |  |  |  |  |  |  |  |  |  |  | Item Description
 |  |  |  |  | Kit | Document Number |  | Date |  |  |  | Customer ID |  |  |  | Customer Name |  | Unit |  | QTY Invoiced |  | Unit Price |  | Markdown |  | Ext Price
 |  |  |  |  |  | 432 |  | 2011-03-01 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 0 |  |  |  |  |  | 0
 | 0.1002154 |  |  |  |  |  |  |  |  |  |  | metal
 |  |  |  |  |  | 56 |  | 2011-10-14 00:00:00 |  |  |  | bob |  |  |  | bob |  | Each |  | -1 |  | 985.56 |  | 0 |  | -985.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | -1 |  |  |  |  |  | -985.56
 | 000-6584 |  |  |  |  |  |  |  |  |  |  | tire
 |  |  |  |  |  | 675 |  | 2011-07-01 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  | Each |  | 2 |  | 9.64 |  | 0 |  | 19.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 2 |  |  |  |  |  | 19.28
 | 000-6585 |  |  |  |  |  |  |  |  |  |  | brake
 |  |  |  |  |  | 675 |  | 2011-07-01 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  | Each |  | 2 |  | 6.24 |  | 0 |  | 12.48
 |  |  |  |  |  | 741 |  | 2011-07-06 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  | Each |  | 2 |  | 6.24 |  | 0 |  | 12.48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 4 |  |  |  |  |  | 24.96
 | 000-6619 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 675 |  | 2011-07-01 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  | Each |  | 4 |  | 7.14 |  | 0 |  | 28.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 4 |  |  |  |  |  | 28.56
 | 000-6626 |  |  |  |  |  |  |  |  |  |  | light
 |  |  |  |  |  | 715 |  | 2011-04-20 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  | Each |  | 2 |  | 10.95 |  | 0 |  | 21.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 2 |  |  |  |  |  | 21.9
 | 000-6629C |  |  |  |  |  |  |  |  |  |  | reflector
 |  |  |  |  |  | 599 |  | 2011-01-12 00:00:00 |  |  |  | rod |  |  |  | rod |  | Each |  | 1 |  | 248.89 |  | 0 |  | 248.89
 |  |  |  |  |  | 205 |  | 2011-08-30 00:00:00 |  |  |  | ron |  |  |  | ron |  | Each |  | 1 |  | 238.06 |  | 0 |  | 238.06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 2 |  |  |  |  |  | 486.95
 | 000-6634 |  |  |  |  |  |  |  |  |  |  | seat
 |  |  |  |  |  | 715 |  | 2011-04-20 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  | Each |  | 2 |  | 13.89 |  | 0 |  | 27.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 2 |  |  |  |  |  | 27.78
 | 000-6639 |  |  |  |  |  |  |  |  |  |  | cushion
 |  |  |  |  |  | 205 |  | 2011-08-30 00:00:00 |  |  |  | ron |  |  |  | ron |  | Each |  | 1 |  | 1.99 |  | 0 |  | 1.99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 1 |  |  |  |  |  | 1.99
 | 000-6641 |  |  |  |  |  |  |  |  |  |  | screw
 |  |  |  |  |  | 490 |  | 2011-04-12 00:00:00 |  |  |  | ray |  |  |  | ray |  | Each |  | 3 |  | 27.4 |  | 0 |  | 82.2
 |  |  |  |  |  | 851 |  | 2011-04-26 00:00:00 |  |  |  | [NAME] |  |  |  | [NAME] |  | Each |  | 3 |  | 27.13 |  | 0 |  | 81.39
 |  |  |  |  |  | 363 |  | 2011-06-21 00:00:00 |  |  |  | tod |  |  |  | [NAME] |  | Each |  | 6 |  | 27.13 |  | 0 |  | 162.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Total: |  |  |  | 12 |  |  |  |  |  | 326.37