Generate experiment labels based on multiple criteria entered into an info sheet

Hi there,

I work in a microbiology lab and I am trying to generate experiment labels based on multiple yes/no criteria. I have created an “Info” sheet in which we will enter our necessary dates, samples, necessary dilutions needed per test, and which tests will be running per sample. I have also gone through and created each possible label needed via a formula (on a separate tab).

My goal is to use the Info sheet to tell Excel which of the created labels need to be copied on to the “To Print” sheet, which I have formatted to fit onto Avery Address Labels.

I think the easiest thing to do would be to use VBA to create a button in order to do this, but I have no experience at this and all of the videos and tutorials I have been watching are too basic – I can’t seem to find anyone who has done this before. Any tips for me? I have included 2 screenshots – one of my Info tab and another one of a piece of my labels tab showing the formula I am using to generate the labels.

I wasn’t sure exactly how to post the photos, let me know if there is a better way.

Info tab:



Thank you for your time!


By: Abbey

Leave a Reply

Your email address will not be published. Required fields are marked *