Is this even possible? Big project question!!

[Lifeisamitch]

Hey guys,

So our LIMS system is down and I'm finding our labelling system is taking forever to do manually. I am wondering if there is possibly an easier way to program this...

Some background:

Columns labelled LIMS Number and Type will be emailed where we copy from the email and paste into the columns labelled Paste Info Here.

Depending if it is an apple, orange, or banana, I need excel to copy the amount of cells from the right category under (K) and paste it under the Info column to the left of the sheet. I will also need it to duplicate the cells if the Replicate column shows that we need to do it in duplicate (or triplicate), etc.

I am posting a few photos for clarification. The first is what the file looks like before the user inputs the sample list from the email.
The next few show what I want the excel function to do.


Pictures are here, but are in backwards order:

https://1drv.ms/f/s!Ar8u4FWifUGCjRTFY2WVJKs-QOWM

Let me know if you need any clarification or if there's a better way to do this.

Thanks in advance!