How do I compare two worksheets, and get the results in other worksheets?

[hrprabhu]

My work has banned MS Access databases. I am finding it hard to manipulate data as required in MS Excel.

Attached is an excel workbook with 5 worksheets. The worksheet names are “PreviousFN”, “CurrentFN”,”Omissions”,” Additions” and “ChangedDetails”

I receive a report every fortnight with 5,000+ records. The first thing I do is I delete all the data from ”PreviousFN”, copy the “CurrentFN” data and paste it into “PreviousFN” and then I clear data from the other four “CurrentFN”,”Omissions”,” Additions” and “ChangedDetails” worksheets.

I then import data from the latest report into “CurrentFN”. Field EID is the key.

What I want to do is to Compare “CurrentFN” and “PreviousFN” and get:

Omitted members pasted into “Omissions”

New members pasted into “Additions”

Apart from field “EID” the values in other fields could change. If that happens, I want to put those records in “ChangedDetails”

I was using Ms Excel 15+ years ago.

Thanks.