View Single Post
  #1   Report Post  
Posted to microsoft.public.access.modulesdaovba,microsoft.public.excel.programming
Herbert Chan Herbert Chan is offline
external usenet poster
 
Posts: 26
Default VBA Function that mimics the Access Not Matching Query

Hello,

I've a spreadsheet in Excel and I have some data.

I want to be able to extract the data from set1 that are not in set2. In
Access, that will be a nonmatching query. However, in Excel, how do I do it
with VBA function? Any written functions already out there?

Thanks.

Herbert