VBA Copy/Paste Data Based Off ActiveX Dropdown Box

Hi,

I am trying to get my idea to work but I have tried several recommendations off various forums with no luck. Hopefully someone can give me a helping hand here.

What I am trying to do is copy data from "Fluids" and paste it to "Plots" based off dropdown box selection. I have used Listfillrange to populate the dropdown box based off data in "Fluids".

My goal here is to copy the data From "Fluids" cells B3,C3,D3 paste to "Plots" F10,G10,H10 / "Fluids" cells E3,F3 paste to "Plots" E13,F13 if user selected 'Spectro Ultra Light' from dropdown box.

I am attaching the sheet here so you can actually see what I am trying to do.

Thanks in advance for any assistance anyone might be able to offer.

Terry

I have been looking all over the web and I found so many different vba codes that I just had sensory overload. I appreciate the time you took coding this and as I am looking at it things are starting to make sense as to how it all works.

Thanks Again!!

Terry