Label Creating Macro/VBA

[John Swift]

Hello and thank you in advance for any help that you can offer.

In my job I have to print out thousands of labels in a day starting with 2 capital letters and 8 numbers with the corresponding bar code underneath in the next cell. e.g. AA00000001
At the moment i have 2 options
1. print each one out individually to get the format I want.
2. write in column A the first number and have excel auto fill down with the bar codes in column B. doing it this way I don't get the format i want as I am using a zebra printer so I only get the bar code with no identifier.
To get my bar code to work it has to have this as the cell contents ="*"&A1&"*" if the cell was A1 that I have my number in with the specific bar code I use which is 3 of 9 extended.

So basically I need a macro that will print both the number on top with a bar code underneath start from one specific number and create so many at one time.

This can be done by any means whether it is a loop macro that creates one and the prints it out then adds one and loops or it auto fills down and then I can print it out or any other way that it is available.

Again thank you in advance for any help that you can offer me

John Swift.

[mrice]

Bit confusing - can you supply a mock-up image of what you hope to get in Excel before it is printed?

[John Swift]

example.png

this is an example of what I need to print along eith the code in cell a2 that is required to make the barcode I need

thank you for your help

[mrice]

Thanks but still a bit confused - would your desired workbook look like the attached? Note the example is just visual and doesn't have any macro code at present.

[John Swift]

That is exactly it you read my mind if that is possible it would be perfect

thank you very much

[mrice]

Please have a look at the attached.

[John Swift]

That is brilliant and just what I was looking for. However there is one slight problem and that is for the bar code to work it need to have no spaces in it it comes out like this ="*" & A1 & "*" when it needs to be ="*"&A1&"*" to work properly.

Again I am truly thankful for your help.

[mrice]

Slight modification attached.

[mike7952]

mrice code modified

Please Login or Register  to view this content.

[John Swift]

hello both and again thank you