xls database, how can I combine 1 column from multiple worksheets to give one long selection list? 关注

0
Avatar
Jim Mason

My customer makes bottled drinks and we have to produce pallet labels. The pallet information is all generated from the barcode number on the cartons, which is unique for each pack size. The problem is the customer has their xls book setup with for example cartons of 6x250ml orange in a worksheet titled "6packs". This will have the unique number for cartons of 6 x 250ml orange. But they have many other worksheets, for example "12packs" and this will contain the number for 12 x 250ml orange. To avoid errors the operators wish to populate the label by picking a record from the unique carton barcode number.

This means I have to search through each sheet one by one until I find a match. I can then extract the product information also required for the label.

e.g.

Worksheet "6packs"

Product Code              Description   Outer case barcode

05000000123          250ml Orange     05000000789

05000000124          250ml Lemon      05000000790

 

Worksheet "12packs"

Product Code              Description   Outer case barcode

05000000123          250ml Orange     05000000791

05000000124          250ml Lemon      05000000792

 

I need the operator to be able to select at print time from a list

05000000789

05000000790

05000000791

05000000792

How do I combine the numbers in all the worksheets into one list so the operator can select it?

Any help will be much appreciated.

请先登录再写评论。