Hi all,

I want to do in macro if possible, if someone know please help me

I have two data which is placed in B1 and B2 cells, I want to match the details given which is jumbled it has to color the matching data,

Here is the detail

in B1 cell

RPN F74262-000 SAP Mat ... Buyer Mat ... Qty 5,000.00 PC WP-508127-5-9

in B2 cell

PO Mat F74262-000 Qty 5,000.00 PC WP-508127-5-9