How do I achieve this? Compare worksheets...

[raghuprabhu]

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.

 

[Ranman256]

Microsoft Access is the tool needed. It will compare 2 worksheets in 1 second.
Excel cannot.
It is a legitimate tool like Excel or Word or PowerPoint.

 

[Rx_]

Agreed, a good choice would be to analyze data in MS Access first.
Then, use one of the many ways to transfer the data into Excel.

 

[raghuprabhu]

Well, I have been able to do it in excel now....please see the attached file.

It took time to learn the different syntax in Excel.

Regards

Raghu