Hello,
I am trying to Find on Sheet1 the mean Annual wages that matches the mean Annual wages on Sheet2.
Once a match is found I would like that copied from Sheet 1 and pasted to the 3rd Sheet named "Matches".
I've done some research and all I could find is a code that looks like this...
Dim rng As Range
Set rng = Range("C:C").Find(What:=ActiveCell.Value, _
LookAt:=xlWhole, MatchCase:=False)
If Not rng Is Nothing Then
rng.Offset(0, 1).Select
End If
It doesn't really make sense but can anyone guide me in the right direction?
Thank You!
Bookmarks