See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
Sub aaa() Dim ChkSH As Worksheet Set ChkSH = Sheets("LM") ce = "Local Market" Sheets("Variance").Activate For Each ce In Range("a4:a" & Cells(Rows.Count, 1).End(xlUp).Row) Set findit = ChkSH.Range("a4:a3000").Find(what:=ce, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False) If findit Is Nothing Then Range("A" & ce.Row).Copy _ ChkSH.Range("a65000").End(xlUp).Offset(1, 0) Next ce End Sub
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!