Hi all,
We are using the following VBA code
Sub Search_and_Match()
Dim sh1 As Worksheet, sh2 As Worksheet
Dim lr As Long, lc As Long, col As Long, lr2 As Long
Dim c As Range, f As Range, r As Range
'
Set sh1 = Sheets("Sheet1")
Set sh2 = Sheets("Sheet2")
lr = sh1.Range("A" &...