EXCEL MACRO: Find & Replace based on sheet

[harky]

I need some help again :D


I need to find from Column A2 below from Data (sheet)
and replace from Column A2 below keyword (Sheet)

replace format as what found in Keyword sheet


A1 is header

 

[harky]

oh my sound strange.. i think i got it wrong?

A1 is header
My result sheet is at DATA sheet A2 below

I suppose need to had 2 table on KEYWORD Sheet?

Table 1 (A2) is the text which found at DATA Sheet?
Table 2 (B2) is the text to be replaced?
If cannot find, just ignore and process the next (no changed done)

 

[harky]

Data sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1 (Header)[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]859[/TD]
[TD]859_[/TD]
[/TR]
[TR]
[TD]859A[/TD]
[TD]859A_[/TD]
[/TR]
</tbody>[/TABLE]

Keyword sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Find (A1)[/TD]
[TD]Replace (B1)[/TD]
[/TR]
[TR]
[TD]859[/TD]
[TD]859_[/TD]
[/TR]
[TR]
[TD]859A[/TD]
[TD]859A_[/TD]
[/TR]
</tbody>[/TABLE]

 

[harky]

Thanks, got my ans from here
https://www.mrexcel.com/forum/excel-questions/970465-find-replace-based-table.html