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

1 | Rep | [NAME] | Region | Ontario | Item1 | 20 | 29 | 30 | 10 | 10 |  | Item2 | 20 | 29 | 30 | 10 | 10 |  | Item3 | 20 | 29 | 30 | 10 | 10 |  | Item4 | 20 | 29 | 30 | 10 | 10 |  | Item5 | 20 | 29 | 30 | 10 | 10 |  | Item6 | 20 | 29 | 30 | 10 | 10 |  | Item7 | 20 | 29 | 30 | 10 | 10 |  | Units | 20 | 29 | 30 | 10 | 10 |  | Cost | 4.99 | 1.99 | 1.99 | 1.29 | 1.29 |  | Unit Total | 99
2 | Rep | [NAME] | Region | Ontario | Item1 | 8 | 71 | 53 | 58 |  |  | Item2 | 8 | 71 | 53 | 58 |  |  | Item3 | 8 | 71 | 53 | 58 |  |  | Item4 | 8 | 71 | 53 | 58 |  |  | Item5 | 8 | 71 | 53 | 58 |  |  | Item6 | 8 | 71 | 53 | 58 |  |  | Item7 | 8 | 71 | 53 | 58 |  |  | Units | 8 | 71 | 53 | 58 |  |  | Cost | 19.99 | 1.29 | 8.99 | 8.99 |  |  | Unit Total | 190
3 | Rep | [NAME] | Region | Ontario | Item1 | 77 | 100 | 68 | 91 | 70 |  | Item2 | 77 | 100 | 68 | 91 | 70 |  | Item3 | 77 | 100 | 68 | 91 | 70 |  | Item4 | 77 | 100 | 68 | 91 | 70 |  | Item5 | 77 | 100 | 68 | 91 | 70 |  | Item6 | 77 | 100 | 68 | 91 | 70 |  | Item7 | 77 | 100 | 68 | 91 | 70 |  | Units | 77 | 100 | 68 | 91 | 70 |  | Cost | 19.99 | 4.99 | 4.99 | 4.99 | 4.99 |  | Unit Total | 406
4 | Rep | Jones | Region | Quebec | Item1 | 47 | 40 | 5 | 30 | 30 | 10 | Item2 | 47 | 40 | 5 | 30 | 30 | 10 | Item3 | 47 | 40 | 5 | 30 | 30 | 10 | Item4 | 47 | 40 | 5 | 30 | 30 | 10 | Item5 | 47 | 40 | 5 | 30 | 30 | 10 | Item6 | 47 | 40 | 5 | 30 | 30 | 10 | Item7 | 47 | 40 | 5 | 30 | 30 | 10 | Units | 47 | 40 | 5 | 30 | 30 | 10 | Cost | 4.99 | 1.99 | 1.29 | 4.99 | 8.99 | 4.99 | Unit Total | 162
5 | Rep | Kivell | Region | Ontario | Item1 | 59 | 80 | 71 | 56 | 56 |  | Item2 | 59 | 80 | 71 | 56 | 56 |  | Item3 | 59 | 80 | 71 | 56 | 56 |  | Item4 | 59 | 80 | 71 | 56 | 56 |  | Item5 | 59 | 80 | 71 | 56 | 56 |  | Item6 | 59 | 80 | 71 | 56 | 56 |  | Item7 | 59 | 80 | 71 | 56 | 56 |  | Units | 59 | 80 | 71 | 56 | 56 |  | Cost | 4.99 | 19.99 | 4.99 | 4.99 | 4.99 |  | Unit Total | 322
6 | Rep | Thompson | Region | Quebec | Item1 | 36 | 99 | 11 | 16 |  |  | Item2 | 36 | 99 | 11 | 16 |  |  | Item3 | 36 | 99 | 11 | 16 |  |  | Item4 | 36 | 99 | 11 | 16 |  |  | Item5 | 36 | 99 | 11 | 16 |  |  | Item6 | 36 | 99 | 11 | 16 |  |  | Item7 | 36 | 99 | 11 | 16 |  |  | Units | 36 | 99 | 11 | 16 |  |  | Cost | 8.99 | 1.29 | 19.99 | 1.99 |  |  | Unit Total | 162
7 | Rep | Smith | Region | Ontario | Item1 | 30 | 26 | 53 |  |  |  | Item2 | 30 | 26 | 53 |  |  |  | Item3 | 30 | 26 | 53 |  |  |  | Item4 | 30 | 26 | 53 |  |  |  | Item5 | 30 | 26 | 53 |  |  |  | Item6 | 30 | 26 | 53 |  |  |  | Item7 | 30 | 26 | 53 |  |  |  | Units | 30 | 26 | 53 |  |  |  | Cost | 15 | 4.99 | 8.99 |  |  |  | Unit Total | 109
8 | Rep | [NAME] | Region | Quebec | Item1 | 28 | 41 | 95 | 98 |  |  | Item2 | 28 | 41 | 95 | 98 |  |  | Item3 | 28 | 41 | 95 | 98 |  |  | Item4 | 28 | 41 | 95 | 98 |  |  | Item5 | 28 | 41 | 95 | 98 |  |  | Item6 | 28 | 41 | 95 | 98 |  |  | Item7 | 28 | 41 | 95 | 98 |  |  | Units | 28 | 41 | 95 | 98 |  |  | Cost | 4.99 | 1.29 | 4.99 | 4.99 |  |  | Unit Total | 262
9 | Rep | Morgan | Region | Ontario | Item1 | 16 | 65 |  |  |  |  | Item2 | 16 | 65 |  |  |  |  | Item3 | 16 | 65 |  |  |  |  | Item4 | 16 | 65 |  |  |  |  | Item5 | 16 | 65 |  |  |  |  | Item6 | 16 | 65 |  |  |  |  | Item7 | 16 | 65 |  |  |  |  | Units | 16 | 65 |  |  |  |  | Cost | 1.99 | 1.99 |  |  |  |  | Unit Total | 81
10 | Rep | Sorvino | Region | Alberta | Item1 | 2 | 28 | 28 | 5 |  |  | Item2 | 2 | 28 | 28 | 5 |  |  | Item3 | 2 | 28 | 28 | 5 |  |  | Item4 | 2 | 28 | 28 | 5 |  |  | Item5 | 2 | 28 | 28 | 5 |  |  | Item6 | 2 | 28 | 28 | 5 |  |  | Item7 | 2 | 28 | 28 | 5 |  |  | Units | 2 | 28 | 28 | 5 |  |  | Cost | 19.99 | 1.99 | 19.99 | 19.99 |  |  | Unit Total | 63