Spreadsheet: 192015d1352289262-merge-multiple-sheets-into-one-sheet-advfilterrep-copy
Sheet: Sheet1

Date | Region | Rep | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Units | Cost | Total
2012-01-02 00:00:00 | Ontario | [NAME] | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 140 | 4.99 | 698.6
2012-01-02 00:00:00 | Ontario | [NAME] | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 56 | 19.99 | 159.92
2012-01-02 00:00:00 | Ontario | [NAME] | 71 | 71 | 71 | 71 | 71 | 71 | 71 | 497 | 1.29 | 91.59
2012-01-02 00:00:00 | Ontario | [NAME] | 77 | 77 | 77 | 77 | 77 | 77 | 77 | 539 | 19.99 | 1539.23
2012-01-02 00:00:00 | Quebec | Jones | 47 | 47 | 47 | 47 | 47 | 47 | 47 | 329 | 4.99 | 234.53
2012-01-02 00:00:00 | Alberta | Jones | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 280 | 1.99 | 79.6
2012-01-02 00:00:00 | Quebec | Jones | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35 | 1.29 | 6.45
2012-01-02 00:00:00 | Alberta | Jones | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 210 | 4.99 | 149.7
2012-01-02 00:00:00 | Ontario | Kivell | 59 | 59 | 59 | 59 | 59 | 59 | 59 | 413 | 4.99 | 294.41
2012-01-02 00:00:00 | Quebec | Thompson | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 252 | 8.99 | 323.64
2012-01-02 00:00:00 | Ontario | Smith | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 210 | 15 | 450
2012-01-15 00:00:00 | Quebec | [NAME] | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 196 | 4.99 | 139.72
2012-01-15 00:00:00 | Quebec | [NAME] | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 287 | 1.29 | 52.89
2012-01-15 00:00:00 | Quebec | Jones | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 210 | 8.99 | 269.7
2012-01-15 00:00:00 | Quebec | Jones | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 70 | 4.99 | 49.90000000000001
2012-01-15 00:00:00 | Alberta | Smith | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 182 | 4.99 | 129.74
2012-01-15 00:00:00 | Ontario | Kivell | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 560 | 19.99 | 1599.2
2012-01-15 00:00:00 | Ontario | Kivell | 71 | 71 | 71 | 71 | 71 | 71 | 71 | 497 | 4.99 | 354.29
2012-01-15 00:00:00 | Ontario | Morgan | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 112 | 1.99 | 31.84
2012-01-15 00:00:00 | Ontario | Morgan | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 455 | 1.99 | 129.35
2012-01-15 00:00:00 | Alberta | Sorvino | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 14 | 19.99 | 39.98
2012-01-15 00:00:00 | Alberta | Sorvino | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 196 | 1.99 | 55.72
2012-01-29 00:00:00 | Ontario | [NAME] | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 700 | 4.99 | 499
2012-01-29 00:00:00 | Ontario | [NAME] | 68 | 68 | 68 | 68 | 68 | 68 | 68 | 476 | 4.99 | 339.32
2012-01-29 00:00:00 | Ontario | [NAME] | 91 | 91 | 91 | 91 | 91 | 91 | 91 | 637 | 4.99 | 454.09
2012-01-29 00:00:00 | Ontario | [NAME] | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 490 | 4.99 | 349.3
2012-01-29 00:00:00 | Alberta | Smith | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 371 | 8.99 | 476.47
2012-01-29 00:00:00 | Quebec | Thompson | 99 | 99 | 99 | 99 | 99 | 99 | 99 | 693 | 1.29 | 127.71
2012-01-29 00:00:00 | Alberta | Thompson | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 77 | 19.99 | 219.89
2012-01-29 00:00:00 | Alberta | Thompson | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 112 | 1.99 | 31.84
2012-02-20 00:00:00 | Ontario | [NAME] | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 203 | 1.99 | 57.71
2012-02-20 00:00:00 | Ontario | [NAME] | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 210 | 1.99 | 59.7
2012-02-20 00:00:00 | Ontario | [NAME] | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 70 | 1.29 | 12.9
2012-02-20 00:00:00 | Ontario | [NAME] | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 371 | 8.99 | 476.47
2012-02-20 00:00:00 | Ontario | [NAME] | 58 | 58 | 58 | 58 | 58 | 58 | 58 | 406 | 8.99 | 521.42
2012-02-20 00:00:00 | Alberta | Sorvino | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 196 | 19.99 | 559.7199999999999
2012-02-20 00:00:00 | Alberta | Sorvino | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 35 | 19.99 | 99.94999999999999
2012-02-28 00:00:00 | Ontario | [NAME] | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 70 | 1.29 | 12.9
2012-02-28 00:00:00 | Quebec | [NAME] | 95 | 95 | 95 | 95 | 95 | 95 | 95 | 665 | 4.99 | 474.05
2012-02-28 00:00:00 | Quebec | [NAME] | 98 | 98 | 98 | 98 | 98 | 98 | 98 | 686 | 4.99 | 489.02
2012-02-28 00:00:00 | Ontario | Kivell | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 392 | 4.99 | 279.44
2012-02-28 00:00:00 | Ontario | Kivell | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 392 | 4.99 | 279.44
 |  | TOTAL | 1856 | 1856 | 1856 | 1856 | 1856 | 1856 | 1856