View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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.