How do I achieve this? Compare worksheets... (1 Viewer)

raghuprabhu

Registered User.
Local time
Yesterday, 17:15
Joined
Mar 24, 2008
Messages
154
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.
 

Attachments

  • Import.xls
    47.5 KB · Views: 120

Ranman256

Well-known member
Local time
Yesterday, 20:15
Joined
Apr 9, 2015
Messages
4,339
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_

Nothing In Moderation
Local time
Yesterday, 18:15
Joined
Oct 22, 2009
Messages
2,803
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

Registered User.
Local time
Yesterday, 17:15
Joined
Mar 24, 2008
Messages
154
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
 

Attachments

  • exercise.zip
    41.2 KB · Views: 96

Users who are viewing this thread

Top Bottom