Sub Find_Matches_TUTTI()
Dim CompareRange1 As Variant, CompareRange2 As Variant, CompareRange3 As Variant
Dim x As Variant, a As Variant, b As Variant, c As Variant, d As Variant
Set CompareRange1 = Worksheets("Working Station").Range("B2:B50")
Set CompareRange2 = Worksheets("MDP").Range("B2:B200")
Set CompareRange3 = Worksheets("Console").Range("B2:B50")
d = "140.80.1.1"
For Each x In Selection
For Each a In CompareRange1
If x = a Then x.Offset(0, -1).Value = a.Offset(0, 3).Value
Next a
For Each b In CompareRange2
If x = b Then x.Offset(0, -1).Value = b.Offset(0, 27).Value
Next b
For Each c In CompareRange3
If x = c Then x.Offset(0, -1).Value = c.Offset(0, 25).Value
Next c
If x = "Auto" Then x.Offset(0, -1).Value = d
Next x
End Sub |