hi folks..

I'm trying to work out how to get a macro or module? to compare two excel sheet and then display all the data onto another sheet.

for example

Sheet1 contains a datalist of 10000 records.
Sheet2 contains a datalist of 2000 records (of which are listed in sheet1)

I want to produce another sheet that contains sheet1 - sheet2.

so it should be something like

compare (sheet1, sheet2)
if record match sheet2! = sheet1! remove record from sheet1!

show results = sheet3

I jsut don't know how to do this , all ideas welcome.

Thanks...