copy a value from a column to another sheet depending on drop down menu in another column

I am trying to make an automated invoice system and need to be able to copy/add the correct value from one sheet to another with the click of a button depending on a selection of a drop down menu. The button works as it should the problem is where "G" does not place the correct "E" in the correct spot. it also needs to add if there is multiple selections in column "G"

INV.png

I need to be able to select from column "G"

inv rcds.png

and have it showing up in the corresponding area on this spread sheet

macro.png

this is the macro/formula I am using, I understand why it doesn't work properly but I don't know how to fix it.

Any help is Greatly appreciated
Thanks in advance!

Hi
Should be

Please Login or Register  to view this content.