Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|can excel files with data model work in excel 2010?||3||41|
|Paste Table from Excel VBA to the PowerPoint 2010||18||55|
|Excel graph in access report||1||33|
|Excel Date Question||8||46|
Join the community of 500,000 technology professionals and ask your questions.