Label Making

Hi All,

I have a problem. I have a spreadsheet with a customers information and various parts we make for them. I need to be able to take this information and incorporate it into a label format. I need something quick and easy as there can be 150 parts per customer

i.e.

Customer: ABCD
Customer PO: 12345

Part Number Quantity
AB 1
CD 15
EF 22
GH 14

and I need it to output:

CUST: ABCD PART: AB
PO: 12345 QTY: 1

CUST: ABCD PART: CD
PO: 12345 QTY: 15

CUST: ABCD PART: EF
PO: 12345 QTY: 22

CUST: ABCD PART: GH
PO: 12345 QTY: 14

Any help would be appreciated. Thanks.

Hello David31,

Are you looking to reformat the data on a worksheet or reformat and print the data as labels? Either way you should a sample workbook so we can see how and where the data is.

Sincerely,
Leith Ross

whoops...sorry about that. There will be 2 tabs in the spreadsheet. One will be where our Customer Service enters the data and one which will take the data and produce a label. I have attached a sample spreadsheet.

Hello David31,

I have added a button on "Sheet1" to run the macro. Here is the macro code. If you decide to rename your worksheets, change the names in red below to match.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Perfect! That's exactly what I was looking for. Thank you very much for your help!

Best regards,
David