VBA code to find the code in both Payer and receiver and do concontate

[julielara]

Dear experts

I have list of business code in list sheet A:A which is reflect in master sheet of payer and receiver range

i want concontate the value of curr&receiver or payer&amount from both side.

for e.g 0M60 Is reflect in payer as well as receiver data also if filter both side towards receiver and payer what code shows concontate along with as "Receiver of" and "payer of"

if i filter 0M60 NOK in payer towards receiver 0M24 shown result will be Payable of NOK ($794055.73)(USD 455155.73) to 0M24 Micros Torex Retail Holdings Europe (UK)
if same code 0M60 NOK in receiver towards payer 0038 shown result will be Receivable of NOK ($78,455,566) (USD -93760622.64) from 0038 - Fidelity

Find the attachment

[julielara]

any experts have quick solution?