How to find what's not there?

[Guest]

Any help on starting this would be greatly appreciated;
I have to find "new" accounts in a workbook.
Process wise, I think i need to open the "February" workbook,
and row by row look for the account number (column A) in the "January"
workbook.

If it's there, ignore it,
if NOT-then it's new and I need to add its entire row to a new sheet in the
Feb. book.

Thanks.

 

[Don Guillett]

I would use a FIND macro. Record while doing by edit>find>>> and clean it up

 

[SLorenson]

Tell me more, I can use FIND to compare two ranges?

 

[Don Guillett]

Here is a sample of this

Sub findeach()
For Each c In Range("a2:a5")
'MsgBox c
With Sheets("yourworksheetname")
On Error Resume Next
Set mf = .Columns(1).Find(What:=c, LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
If Not mf Is Nothing Then
MsgBox mf & "found at " & mf.Row
End If
End With
Next
End Sub

 

[Guest]

Don,
Sorry for the delay, as I obviously did not post under "programming" like I
thought I did.

Anyway. Thanks very much for your help.
I'm assuming that ("yourworksheetname") can be in a completely different
workbook?