Date Region 1/2/03 Ontario 1/2/03 Ontario 1/2/03 Ontario 1/2/03 Ontario 1/2/03 Quebec 1/2/03 Alberta 1/2/03 Quebec 1/2/03 Alberta 1/2/03 Ontario 1/2/03 Quebec 1/2/03 Ontario 1/15/03 Quebec 1/15/03 Quebec 1/15/03 Quebec 1/15/03 Quebec 1/15/03 Alberta 1/15/03 Ontario 1/15/03 Ontario 1/15/03 Ontario 1/15/03 Ontario 1/15/03 Alberta 1/15/03 Alberta 1/29/03 Ontario 1/29/03 Ontario 1/29/03 Ontario 1/29/03 Ontario 1/29/03 Alberta 1/29/03 Quebec 1/29/03 Alberta 1/29/03 Alberta 2/20/03 Ontario 2/20/03 Ontario 2/20/03 Ontario 2/20/03 Ontario 2/20/03 Ontario 2/20/03 Alberta 2/20/03 Alberta 2/28/03 Ontario 2/28/03 Quebec 2/28/03 Quebec 2/28/03 Ontario 2/28/03 Ontario
Rep Anderson Gill Gill Jardine Jones Jones Jones Jones Kivell Thompson Smith Howard Howard Jones Jones Smith Kivell Kivell Morgan Morgan Sorvino Sorvino Jardine Jardine Jardine Jardine Smith Thompson Thompson Thompson Anderson Anderson Anderson Gill Gill Sorvino Sorvino Anderson Howard Howard Kivell Kivell
Item Clipboards Binders Pens Binders Clipboards Pens Pen Sets Pen Sets Pen Sets Binders Binders Clipboards Pens Binders Clipboards Pen Sets Binders Pen Sets Pens Pen Sets Binders Pens Clipboards Clipboards Pen Sets Pen Sets Binders Pen Sets Binders Pens Pens Pens Pens Binders Binders Binders Binders Pens Clipboards Clipboards Pen Sets Pen Sets
Units 20 8 71 77 47 40 5 30 59 36 30 28 41 30 10 26 80 71 16 65 2 28 100 68 91 70 53 99 11 16 29 30 10 53 58 28 5 10 95 98 56 56
Cost 4.99 19.99 1.29 19.99 4.99 1.99 1.29 4.99 4.99 8.99 15.00 4.99 1.29 8.99 4.99 4.99 19.99 4.99 1.99 1.99 19.99 1.99 4.99 4.99 4.99 4.99 8.99 1.29 19.99 1.99 1.99 1.99 1.29 8.99 8.99 19.99 19.99 1.29 4.99 4.99 4.99 4.99
Total 99.80 159.92 91.59 1539.23 234.53 79.60 6.45 149.70 294.41 323.64 450.00 139.72 52.89 269.70 49.90 129.74 1599.20 354.29 31.84 129.35 39.98 55.72 499.00 339.32 454.09 349.30 476.47 127.71 219.89 31.84 57.71 59.70 12.90 476.47 521.42 559.72 99.95 12.90 474.05 489.02 279.44 279.44
Create sheet with for each rep filtered list If a sheet already e a rep, it will be clea the data will be ext that sheet
Create sheet with records for each rep in filtered list If a sheet already exists for a rep, it will be cleared, and the data will be extracted to that sheet