Hi,
In column A of worksheet "EOK1" are unit numbers (exp:2spf25006). I would like a macro that will look in another sheet named "results" and find that unit number. Once it finds that unit number it copies the column next to that unit number on the "results" sheet and paste it to a column on the EOK1 sheet named stem 3 in the same row. Can someone help me out with this it will be greatly appreciated. THIS IS TEST COPY DO NOT USE THIS (Autosaved)2.xlsm