Spreadsheet: 113823d1309706258-pull-column-from-one-sheet-to-another-affiliated-new-order-book
Sheet: Cooler

Order | Item # | UPC # | Name | Cost | % |  | # of Items | SRP
2 | 45975 | 0-52000-32673 | Gatorade Fierce Grape 32 oz | 19.92 | 0.26 |  | 12
2 | 45982 | 0-52000-33875 | Gatorade Fruit Punch 32 oz | 19.92 | 0.26 |  | 12
2 | 45980 | 0-52000-33877 | [NAME] 32 oz | 19.92 | 0.26 |  | 12
2 | 45976 | 0-52000-33876 | Gatorade Orange 32 oz | 19.92 | 0.26 |  | 12
3 | 45997 | 0-52000-32432 | Gatorade Rain Lime 32 oz | 19.92 | 0.26 |  | 12
3 | 45996 | 0-52000-32555 | GATERADE COOL BLUE 32 oz |  | 0.25 |  | 0
3 | 46074 | 0-52000-24123 | Gatorade Cool Blue Rasbe 24 oz | 32.2 | 0.26 |  | 24
2 | 46072 | 0-52000-24129 | Gatorade Edge Fierce Grape 24 oz | 32.2 | 0.26 |  | 24
2 | 46056 | 0-52000-24121 | Gatorade Edge Fruit Punch 24 oz | 32.2 | 0.26 |  | 24
1 | 46055 | 0-52000-24120 | [NAME] 24 oz | 32.2 | 0.26 |  | 24
5 | 37324 | 0-22592-05301 | [NAME] Spring 24pk/1  (cooler) | 5.13 | 3.65 |  | 24
0 | 37321 | 0-22592-71005 | [NAME] (sport) | 15.93 | 0.85 |  | 28
1 | 37378 | 0-22592-00811 | [NAME] (small bottles) | 11.24 | 0.42 |  | 4
2 | 37325 | 0-22592-74319 | [NAME] Spring 33.8 (liters) | 12.86 | 0.35 |  | 18
0 | 37331 | 0-22592-00005 | OZARKA WATER SPRING GAL | 6.11 | 0.35 |  | 6
0 | 37308 | 0-22592-00009 | OZARKA WATER DRINKING GAL | 5.66 | 0.35 |  | 6
0 | 17137 | 0-00000-04061 | LETTUCE CELLO PREMIUM | 28.88 | 0.35 |  | 24
1 | 17160 | 0-00000-04064 | TOMATO 25# 5X6 | 27.99 | 0.35 |  | 25
0 | 17218 | 0-00000-04663 | ONION WHITE MED/LG | 26.99 | 0.35 |  | 47
0 | 69490 | 0-75386-04954 | PUEBLITO NACHO SLI JAL FIELD | 36.36 | 0.35 |  | 6
0 | 56044 | 0-70152-80108 | BM RELISH SWEET | 34.39 | 0.35 |  | 4
1 | 56628 | 0-70152-80104 | BM PICKLES HB SLI | 25.91 | 0.35 |  | 4
2 | 3519 | 0-00000-00000 | WILSON VIRGINIA SMOKED HAM | 100.33 | 0.35 |  | 2
0 | 3564 | 0-00000-00000 | [NAME] |  | 0.35 |  | 1
2 | 3577 | 0-00000-00000 | BBALL MESQUITE SMK TKY BRST RW | 71.2 | 0.35 |  | 1
0 | 3958 | 0-82004-83944 | HML CKD ROAST BEEF | 52.3 | 0.35 | 30.06 | 2
0 | 3570 | 0-00000-00000 | [NAME] |  | 0.35 |  | 1
0 | 3544 | ------ | KRETSCHMAR P&P LOAF | 15.9 | 0.35 |  | 2
1 | 3562 | ------ | WILSON PEPPER LOAF | 18.67 | 0.35 |  | 2
4 | 8062 | 0-10393-10493 | SCH HOT PEP/JACK LOAF WHITE | 14.78 | 0.35 |  | 1
0 | 8038 | 0-21000-60001 | KRAFT AMERICAN LOAF | 77.42 | 0.35 |  | 6
0 | 2462 | 0-79621-46100 | WRT STACK PAK BACON | 145.51 | 0.35 |  | 20
0 | 3807 | 0-76713-00004 | [NAME] |  | 0.35 |  | 1
0 | 11162 | 0-15400-83135 | SF CHS COLBY L/HORN HALF MOON | 35 | 0.3 |  | 12
1 | 12255 | 0-28000-24630 | NESQUICK CHOCOLATE MILK |  | 0.25
2 | 125 | 0-71044-00126 | PLAINS SNACK ATTACK CHOC |  | 0.25
2 | 124 | 0-71044-00006 | PLAINS SNACK ATTACK HOMO |  | 0.25
4 | 211 | 0-41330-70009 | PLAINS MILK 1% - HG SINGLE |  | 0.25
1 | 156 | 0-71044-00023 | PLAINS 2% MILK GALLON -6 | 21.57 | 0.35 |  | 6
1 | 12295 | 0-41330-70141 | PLAINS FRENCH ONION DIP | 9.83 | 0.35 |  | 6
0 | 228 | 0-15400-20289 | SF Sour Cream - 6/16 oz |  | 0.35 |  | 1
3 | 110 | 0-15400-20291 | SF Sour Cream S |  | 0.35 |  | 1
0 | 14143 |  | EGG MAHARD JUMBO A EXP DATE | 28.74 | 0.35 |  | 18
0 | 22679 | 0-51000-06501 | HGRYMAN SALISBURY STEAK DINNER | 25.25 | 0.35 |  | 8
0 | 22681 | 0-51000-06514 | HM CLASSIC FRIED CHK DINNER | 28.04 | 0.35 |  | 8
0 | 23629 | 0-71921-00519 | TOMBSTONE PIZZA PEPPERONI 12" | 68.69 | 0.25 |  | 12
0 | 45337 | 0-16300-15080 | FLORIDA 100% ORANGE JUICE - 16 oz | 14.77 | 0.35 |  | 12
0 | 45282 | 0-41800-20350 | WELCHES GRAPE JUICE - 24 oz | 24.08 | 0.35 |  | 12
6 | 331 |  | RED DIAMOND SWEET TEA - 24 oz | 13.81 | 0.25 |  | 12
0 | 12697 |  | RED DIAMOND SWEET TEAD - 1 gal | 15.41 | 0.25 |  | 6
0 | 362 | 0-47677-22961 | KEMPS SNICKERS KING SZ BA | 52.37 | 0.25 |  | 48
0 | 688 | 0-70640-00249 | B/B STRAW SHORTCAK KING S | 14.61 | 0.25 |  | 24
0 | 782 | 0-12971-24236 | BIG NEOPOLITAN SANDWICH | 13.35 | 0.45 |  | 24
0 | 678 | 0-70640-45060 | B/B TURTLE SUNDAE BAR |  | 0.25 |  | 24
0 | 361 | 0-47677-22969 | KEMPS TWIX KING SIZE BAR |  | 0.25 |  | 0
1 | 17277 | 0-33383-11010 | ORANGE BAG NAVEL |  | 0.25 |  | 0
0 | 19089 | 0-00000-04235 | BANANAS PLANTAIN 1/2 CASE |  | 0.25 |  | 0
0 | 17032 | 0-00000-04016 | APPLES RED XF 56 |  | 0.25 |  | 0
1 | 17050 | 0-00000-04022 | GRAPES GREEN SDLS LG - 1/18 LB |  | 0.25 |  | 0
0 | 19300 | 0-00000-00000 | CANTALOUPE MAG DEL MONTE - 11 CT |  | 0.25 |  | 0
0 | 17048 | 0-00000-04045 | CHEERIES RED 1/16 LB |  | 0.25 |  | 0
2 | 58430 | 0-21000-63316 | KRAFT MIRACLE WHIP - GAL |  | 0.25 |  | 0
0 | 56050 | 0-70152-80137 | BM MUSTARD PURE - GAL |  | 0.25 |  | 0
6 | 20042 | 0-74608-35110 | ICE CRUSHED BAGGED - 5/10 LB |  | 0.25 |  | 0
0 | 8170 | 0-30900-46741 | PAULY BABY SWISS |  | 0.25 |  | 0
0 | 24175 | 0-78004-01241 | GRANDMAS GRANDE FLOUR 10" |  | 0.25 |  | 0
2 | 37361 | 0-14800-51176 | MOTTS CLAMATO |  | 0.25