More help on Find and Replace from one sheet to the next

I'm trying to find and replace cells by looking at a value from one sheet, and replacing it with a value from another sheet.
I'm currently modifying a code from my last thread by jolivanes (thank you!)

I think I'm running into an issue using this code because some of the cells are combined, so it's not properly searching down the column. But I'm not sure.

The code should:
1. Find a name from (Sheet 1 column A) in (Sheet 2 column E)
2. If it's found, then replace (Sheet 2 Column K, same row) with the value from (Sheet 1 column B, same row)

Please Login or Register  to view this content.

I've attached a sample worksheet to give you an idea of how the values might look.

Originally Posted by maras_mak

Test my solution.

Thanks Mara. The solution works on the sample sheet but didn't work on my actual one. The only thing I changed was all instances of (s2) to (s4) and Set s4 as Worksheets("Sheet4")

I get a "Runtime Error '9': Subscript out of range" on the highlighted line.

Please Login or Register  to view this content.

I forgot to mention that the values in Sheet 1 may have random blanks or missing values in it. I'm not sure if that will cause the code to fail.

Ok here's a better sample workbook.

Thank you very much!

You could try this (use from either sheet)

Please Login or Register  to view this content.

Thank you! The solution worked perfectly!