Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-12-2017, 04:35 PM   #1
raghuprabhu
Newly Registered User
 
Join Date: Mar 2008
Posts: 152
Thanks: 43
Thanked 6 Times in 6 Posts
raghuprabhu is on a distinguished road
How do I achieve this? Compare worksheets...

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 Files
File Type: xls Import.xls (47.5 KB, 45 views)

raghuprabhu is offline   Reply With Quote
Old 03-13-2017, 12:21 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,157
Thanks: 0
Thanked 690 Times in 675 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: How do I achieve this? Compare worksheets...

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.
Ranman256 is online now   Reply With Quote
The Following User Says Thank You to Ranman256 For This Useful Post:
raghuprabhu (03-13-2017)
Old 03-13-2017, 08:46 AM   #3
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,781
Thanks: 630
Thanked 333 Times in 305 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Re: How do I achieve this? Compare worksheets...

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.

Rx_ is offline   Reply With Quote
Old 07-29-2017, 07:26 PM   #4
raghuprabhu
Newly Registered User
 
Join Date: Mar 2008
Posts: 152
Thanks: 43
Thanked 6 Times in 6 Posts
raghuprabhu is on a distinguished road
Re: How do I achieve this? Compare worksheets...

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
Attached Files
File Type: zip exercise.zip (41.2 KB, 24 views)

raghuprabhu is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Best way to achieve this? Gasman Forms 5 03-28-2016 10:36 AM
Please Help me to achieve this... shieriel Tables 9 01-19-2011 08:44 PM
Compare Worksheets Trevor G Excel 10 10-21-2010 05:55 AM
Looking For Advice For How to Achieve This... Darrell Wootton General 1 08-27-2004 05:31 AM
How Do I Achieve This? MsLady Queries 3 06-18-2004 05:44 AM




All times are GMT -8. The time now is 06:42 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World