Find & Replace Matching Cells Across Multiple Sheets

Howdy Folks,
Do any of you folks have a solution to the following Excel task I am trying to complete:

I have an Excel file with multiple sheets and I want to find and replace matching cell data on the same row across all of the sheets. For example, I have two columns, Column A and Column C and 10 sheets. I want to only replace the content in Column A if text matches both Column A and Column C on the same row. So, I want to be able to search for the following data across all sheets:

Column A = "car"
Column C = "yellow"

If both "car" and "yellow" are found in Column A and Column C on the same row, then replace "car" in Column A with "truck".


Is there a way to do this automatically as I have few hundred to find and replace?


Thanks folks.

Bump please

Perhaps a macro like this?

Please Login or Register  to view this content.

Alf

Howdy Alf,
You are so great! Thanks for the help, it works perfect!

Glad to be of help and thanks for feedback. If this solves you problem could you please go to first post click on "Thread Tools" and select "Mark thread as Solved"

Alf

Thread marked as solved. Howdy Alf.