filtering out records from one worksheet by comparing a field in it with a field in another workshee

C

case

Hi All,

I'm hoping this is an easy one.
I have 2 worksheets (sheet1 and sheet2)and want to create a 3rd (sheet
3) based on some filtering using the sheet 1 and sheet2. I want to
remove all the records in sheet 1 where the email field matches and
email field somewhere in sheet2. If I can just remove them in sheet 1
then I don't need to create sheet3 at all. Can anyone advise how to do
this?
TIA,

Case
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I match records from two Sheets? 4
Need help to filter data from multipule sheets to specific sheet 2
remove records when fields match in 2 worksheets?? 6
Code to format cells on several worksheets 2
Filters - Unique Records 0
how do i loop thru all the worksheets in 2 files one by one 0
macro for calculate and compare 0
delete duplicates 0

Top