Thread: record filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ikke = Huub Ikke = Huub is offline
external usenet poster
 
Posts: 3
Default record filter

I need a filter to skip records.

I have sheet A with aprox 1500 lines.
I have sheet B with aprox 15 lines.
These two sheets have to be matched.
As result I want sheet A with all the lines that ar not in sheet B
so: the complete line in sheet A that's exactly in sheet B, should be
skipped.

Could it be done with a macro?

Huub