I need to create HUNDREDS of packing Slips... from a single spreadsheet - HOW???

MASTER SHIP LIST BEVMO FROM ANDREA.xlsPacking Slip Template.xlsxFor Excel Forum .xlsxmaster list cartons separated for excel forum..xls

Hello All,

I'm looking for some much needed assistance.
I work for a company that ships large volumes of product to immense numbers of destinations.
I need to figure a way to quickly create packing slips from a single Master Ship List.
Each Row below the header is a different store.
Each Column is a different product - not every store gets every product.
NO zero quantities on the packing slips.

Oh, and to throw in a wrench - Every carton has to have its own packing slip some stores get 3-5 cartons. BUT here's one of the nastiest parts - some of the stores will have 12 of the large signs. Only 8 will fit in a carton, those 12 may be spread out between the 3 "groups". I wont need 3 packing slips for 12 signs, only 2.

I have attached what I've been MANUALLY creating for the past few months using copy/paste (as the poor soul before me) and an old master list, a copy of the master list with the "standard" cartons separated by blacked out columns, AND one store's finished MULTIPLE packing slips - so you can see how horrible this really is.

Quite honestly I'm fed up with it. I literally spend 30+ hours a week IN OVERTIME creating these when these big projects ship and it's killing me. Our IT people were dumbfounded when I asked them for help. PLEASE BE MORE CLEVER THAN THEM!

The final does not need to look like what I've been creating, its just an idea - if it will work.

Any and All help is GREATLY appreciated!!