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

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

  1. ig

    Good post. I learn something totally new and challenging on blogs I stumbleupon every
    day. It’s always interesting to read through content
    from other authors and practice something from their sites.

  2. vurtilopmer

    Great paintings! This is the kind of info that are supposed to be shared around the net. Disgrace on Google for now not positioning this put up upper! Come on over and discuss with my web site . Thank you =)

Comments are closed.