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:

https://drive.google.com/file/d/1X9aoc4yOpbfkTDmZraP6s1-XTrI_3yd-/view?usp=sharing

Labels:

https://drive.google.com/file/d/1ZMEnqcl9chPA3bIbyQhc1X8z4ZcHqgN-/view?usp=sharing

 

Thank you for your time!

 

By: Abbey

Leave a Reply

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