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

Herbert,

I think you'd be better served asking this question in one of the Excel
newsgroups.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Herbert Chan" wrote in message
...
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