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.
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.