Tick a box to create a label

You want to create just one label in sheet?

Here is attempt without macro..

Types are not in your order but they are unique.
I'm guessing there should be easier way for conditional formatting but I can not get it at the moment.

Hi,

Thanks for the reply.

I tried this and I couldn't get it to work. Is there a way I can import the label from the template sheet onto labels sheet with say a tick box or a drop down list? For instance, I click Type 1 and it then populates the cells underneath with that label. I then click type 2 and it populates underneath with type 2. I need the template sheet locked ideally..

Thanks in advance,
Jase

I couldn't get it to work. But if I'm understanding it correctly then that would mean that double clicking the label template would copy it to the label sheet? Yes?

I need the functionality to click something on the labels sheet to fetch the data/formatting from the template sheet. Is this possible?

Originally Posted by Mumps1

Try the attached file. Click the button on the Labels sheet.

That's brilliant! Thank you.

Is there anyway in which I can make it so that this process can be repeated as many times as necessary down the sheet for multiple labels? It's ok if not, just this would be easier for anyone wishing to print various different kinds of labels..

Originally Posted by Mumps1

Try the attached file.

Absolutely perfect. I can't thank you enough!