Macro that allows a search in one column in one worksheet and moves to another

[jcooper14]

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

[AB33]

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

Means the same cell is copied twice: One on sheet result and then again on the same sheet column L. Is this right?

[jcooper14]

So basically it searches the results sheet for the unit numbers found on eok1 sheet if they are there the the dates next to the column on the results sheet back into the eok1 sheet stem3 column across from that unit number. Does that make since? Let me know. Thanks for replying

[AB33]

By next column you meant L as you have hidden columns. This code compares column D of result sheet with column B of eok1 and the return is on column L of sheet eok1.

Please Login or Register  to view this content.

[jcooper14]

By next column you meant L as you have hidden columns. This code compares column D of result sheet with column B of eok1 and the return is on column L of sheet eok1.

Please Login or Register  to view this content.

I honestly dont know how to thank you. You have taken so much time off my day! Thank you for such a fast reply and such a great code! Now if i could get the results of each indivdual page to copy to an email, I would pretty much be set. Thanks again!

[jcooper14]

I was wondering if you can help me with something else. In that program if you notice in the tabs with an "S" at the end have columns in them that change to yes or no depending on the info put in. Was wondering if the columns say yes, which would be columns G,K,O, if it would create an email giving the unit number in column B that is due and put the reason there due. Like 2SPF32796 STEM 2 DUE, HRS ON STEM 102. Or 2SPF32796 STEM 3 DUE, STEM 3 TIME 270. Thanks