Hi all. I would like to use VBA to check a column of values (Column A) for a value (Papaya) and replace a common value(Fruit) in another column which contains values already at the same row. Thanks.

From:
Item Type
Papaya Vegetable
Chilli Vegetable
Papaya Vegetable
Cabbage Vegetable
Potato Vegetable
Cabbage Vegetable

To:
Item Type
Papaya Fruit
Chilli Vegetable
Papaya Fruit
Cabbage Vegetable
Potato Vegetable
Cabbage Vegetable

Hi,

Turn on the macro recorder and then record yourself performing these steps manually:

• Select column A
• CTRL+F
• Replace Tab
• Find What: Papaya Vegetable
• Replace With: Papaya Fruit
• Replace All
• Close

Then it's just a case of reviewing the code that the macro recorder has generated and tidying it up a little.

Let us know how you get on....