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

Order | Item # | UPC # | Name | Cost | % |  | # of Items | SRP
0 | 42062 | 0-29000-07651 | PLNTR DRY ROAST LT SALTED |  | 0.25
2 | 73935 | 7-19410-50001 | 5 HOUR ENERGY BERRY |  | 0.25
0 | 74287 | 0-28000-01077 | BABY RUTH |  | 0.25
0 | 74288 | 0-28000-08700 | BUTTERFINGER |  | 0.25
0 | 74369 | 0-40000-00295 | DOVE DARK CHOCOLATE BAR |  | 0.25
0 | 74516 | 0-10700-06080 | HRSH HEATH TOFFEE BAR |  | 0.25
0 | 74321 | 0-34000-00246 | HRSH KIT KAT |  | 0.25
0 | 74315 | 0-34000-00440 | HRSH REESES PNTBTR CUP |  | 0.25
0 | 74343 | 0-40000-00032 | [NAME] |  | 0.25
0 | 74341 | 0-40000-00031 | M&M Plain Chocolate |  | 0.25
1 |  |  | [NAME]
0 | 74331 | 0-40000-00101 | Milky Way |  | 0.25
0 | 74402 | 0-10700-80722 | PAY DAY |  | 0.25
0 | 74333 | 0-40000-00102 | SNICKERS BAR |  | 0.25
2 | 74354 | 0-40000-00263 | SNICKERS KING SIZE 2 PIECE BAR |  | 0.25
0 | 75025 | 0-11300-38401 | BRACH LEMON DROPS - PEG |  | 0.25
0 | 75390 | 0-34000-13410 | HRSH KISSES - PEG |  | 0.25
1 | 74985 | 0-10700-70230 | J RANCHER ASSORTED BAG - PEG |  | 0.25
0 | 75375 | 0-40000-01732 | [NAME] |  | 0.25
0 | 74454 | 0-72799-05027 | RIESEN CHOCOLATE - PEG |  | 0.25
0 | 75063 | 0-15400-84185 | SF STARLIGHT MINTS - PEG |  | 0.25
1 | 74385 | 0-72181-00501 | DEMETS TURTLES BAR |  | 0.25
1 | 74511 | 0-34725-00120 | [NAME] PATTIE |  | 0.25
0 | 73343 | 0-12546-67003 | TRIDENT GUM WINTERGREEN |  | 0.25
0 | 73159 | 0-22000-00668 | [NAME] |  | 0.25
0 | 73160 | 0-22000-00666 | [NAME] |  | 0.25
0 | 73161 | 0-22000-00667 | Wrigley Juicy Fruit |  | 0.25
0 | 74156 | 0-22000-15935 | ALTOIDS CINNAMON |  | 0.25
0 | 74144 | 0-34000-00764 | Breath Saver Peppermint |  | 0.25
0 | 74108 | 0-12546-71360 | CERTS MIXED FRUIT |  | 0.25
0 | 74200 | 0-09800-00763 | TIC-TAC ORANGE BIG PK |  | 0.25
0 | 74379 | 0-34000-00031 | HRSH MOUNDS DRK CHOC |  | 0.25
0 | 74375 | 0-34000-00320 | HRSH ALMOD JOY |  | 0.25
0 | 74335 | 0-40000-00003 | 3-MUSKETEERS BAR |  | 0.25
0 | 74345 | 0-40000-00144 | [NAME] |  | 0.25
0 | 74358 | 0-40000-40265 | M&M CHOCOLATE PRETZEL |  | 0.25
0 |  |  | [NAME] |  | 0.25
0 | 73605 | 0-71720-00007 | T-ROLL POPS ASSRT |  | 0.25
0 |  |  | Sweathearts |  | 0.25
0 | 73581 | 0-10700-00010 | J RANCHER LOLLIPOP |  | 0.25
0 | 74587 | 0-40000-00160 | SKITTLES ORIGINAL FRUIT C |  | 0.25
0 | 74612 | 0-22000-01080 | LIFESAVERS GUMMIE 5 FLVR |  | 0.25
0 | 74325 | 0-34000-00247 | HRSH WHATCHAMCALLIT |  | 0.25
1 | 74338 | 0-40000-00105 | SNICKERS ALMOND |  | 0.25
0 | 74590 | 0-40000-00877 | STARBURST SUMMER FUN FRUIT |  | 0.25
1 | 29400 | 0-23604-21360 | TWANG SHAKERS LEMON LIME |  | 0.25
 |  |  | Wrigley Spearmint
 |  |  | Breath Savers Spearmint
 |  |  | Breath Savers Wintergreen
 |  |  | [NAME]
 |  |  | Wonka Laffy Taffy Strawberry
 |  |  | Wonka Laffy Taffy Sour Apple
 |  |  | Super Bubble Orginal
 |  |  | Trident Orginal Flavor
 |  |  | Trident Spearmint Flavor
 |  |  | Nature Valley Trail Mix
 |  |  | Nature Valley Oats & Honey
 |  |  | [NAME]'s Milk Chocolate
 |  |  | [NAME] Peanut Clusters
 |  |  | Hersey's Almolds
 |  |  | Planters Mix
 |  |  | Planters [NAME]
 |  |  | Planters Roasted
 |  |  | [NAME]
 |  |  | Karo Light Corn Syrup
 |  |  | Waffle Syrup
 |  |  | Kellogs Frosted Flakes
 |  |  | [NAME]
 |  |  | Breakfest Ess
 |  |  | [NAME]
 |  |  | Tidy Cats