How to find what's not there?
 

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.

How to find what's not there?
 

I would use a FIND macro. Record while doing by editfind and clean it up

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"< AVG Joe" wrote in message
...
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.

How to find what's not there?
 

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

"Don Guillett" wrote:

I would use a FIND macro. Record while doing by editfind and clean it up

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"< AVG Joe" wrote in message
...
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.


.

How to find what's not there?
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SLorenson" wrote in message
...
Tell me more, I can use FIND to compare two ranges?

"Don Guillett" wrote:

I would use a FIND macro. Record while doing by editfind and clean it
up

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"< AVG Joe" wrote in message
...
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.


.

How to find what's not there?
 

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?

"Don Guillett" wrote:

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SLorenson" wrote in message
...
Tell me more, I can use FIND to compare two ranges?

"Don Guillett" wrote:

I would use a FIND macro. Record while doing by editfind and clean it
up

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"< AVG Joe" wrote in message
...
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.


.


.