Find and Replace across multiple rows and sheets


New Member
Hi Everyone,

TYIA for the assistance!

I need Find and Replace to work with a little logic.

I have two-sheet workbook with related values in columns A & B in sheet 1.
Sheet 2 has a selection of values from sheet1 column B along with some other required information.

I need for replace the Column B values in sheet 2 with the A values from Sheet 1

Here are images with demo data of the two sheets:
Last edited by a moderator:

Some videos you may like

This Week's Hot Topics