Find and Replace Macro Based on Specific Cells

Hello all. After much fretting over this (and many other Excel issues), I've decided to seek out some assistance. I've included an example with columns, because I'm not very fluent in Excel terminology.

Please Login or Register  to view this content.

I want to create a macro that will take the text from A1 on worksheet 2, find that text on worksheet 1, then replace A2 on worksheet 1 with A2 on worksheet 2.

In other words, I want the macro to (in this example), find "Alpha" in worksheet 1, then replace "Apple" on worksheet 1 with "Apricot" from worksheet 2.

Apologies if this is not clear: I'm still having trouble expressing myself when it comes to Excel.

Hi EvoDE
Codes untested but try something like...

Please Login or Register  to view this content.

I suspect Pike has answered your question but could you explain this bit:

Originally Posted by EvoDE

In other words, I want the macro to (in this example), find "Alpha" in worksheet 1, then replace "Apple" on worksheet 1 with "Apricot" from worksheet 2.

I am presuming "able" in your screenshot should thus actually be "Alpha" else this doesn't make much sense ... (to me at least but it's early!)

Thanks for the confindece DonkeyOte
but the tested code should be..

Please Login or Register  to view this content.

hey EvoDE
can you go back to your fist post and click edit
then choose advanced and change the prefix to solved

the code is standard find replace code - it use to solve most find replace posts