Find and Replace using cells on different sheets

Are the A, B, C, etc Rows?

If you mean what I think you mean, this might do it.

Please Login or Register  to view this content.

Originally Posted by jolivanes

Are the A, B, C, etc Rows?

No, they are values in the column.

So Cell A1 has value "A", Cell A2 has value "B", Cell A3 has value "C".

Did you happen to try the code?

I did, and it works beautifully.

How can I edit the code so that it works with Column C instead of B? I'm assuming it has to do wit the Offset

Originally Posted by jolivanes

Yes, change the (, 1) to (, 2)

You beautiful human being

Thanks!

Am I understanding the code correctly?

Please Login or Register  to view this content.

I was trying to use find replace, but this method is almost like coding out the steps of find replace.

Could you explain the Countif section?

Glad it works for you. I added some info to Post #7. Don't know if you seen it.

Got it, thank you very much

All the code does is loops through the cells in Column A of Sheet1 and checks if the value of that cell exists in Column A of Sheet2 with Countif.
It checks a range to see if it meets a certain criteria, in this case the value of a cell. A result of zero (0) means it did not.
If it does not, it just skips and goes to the next cell.