Creating labels/pasting an amount specified in a cell.

[Andy1984]

Hi Everyone,

I have browsed this forum often in the past but have always found a solution to my problem in older posts (my knowledge of VBA is not yet sufficient enough to post replies myself) but this time I am stumped.

I am working for a logistics company who want to produce labels in a quick and easy way so want to use an excel workbook with two sheets. One sheet will have the input criteria, and one will have cells set to a fit size to allow them to print straight onto Avery labels.

Sheet1, the sheet with the input criteria, will use something like drop down boxes with links to cells so you can select hat you want your labels to say and how many of them you would like printed. As each van has different produce, they need more than one description for each van load. When you press a button, I am trying to use VBA to then use this information to enter into the cells in sheet2 so that the labels can be created.
I have put a simplified version below in case my description is inadequate.

7534709_orig.jpg

I have tried using every piece of VBA that I know (not too much) and I just can’t get it to work. Is there anyone out there who could help me with this?

Many thanks,

Andy

[Andy1984]

Any suggestions would be much appreciated.

I can only think of doing a VERY long if function covering all inevitability of label numbers along the lines of:

IF 1st Combobox stating required number of labels = 1 And Combox 2 and 3 = 0 Then 1st label cell = Combobox 1

And so on. My only concern is it may make the workbook a bit slow as it would have to be very long.