ArisaAnsar
asked on
Looking for suggestions (What application to use)?
I have two excel files (both have approximately 65000 rows).
One is my base file (starting file) and each week I received an updated version. My goal is to compare the two files to see if any new accounts was added or deleted. In addition, if the accounts remain on the file each week, check if there have been any changes to the value in column E-H.
It takes two much time to do this manually. Does anyone have any suggestion how to process this quicker?
I'm afraid excel VBA will take 4 hours if I run in excel VBA.
Starting-File.xlsx
Updated-Weekly-File.xlsx
One is my base file (starting file) and each week I received an updated version. My goal is to compare the two files to see if any new accounts was added or deleted. In addition, if the accounts remain on the file each week, check if there have been any changes to the value in column E-H.
It takes two much time to do this manually. Does anyone have any suggestion how to process this quicker?
I'm afraid excel VBA will take 4 hours if I run in excel VBA.
Starting-File.xlsx
Updated-Weekly-File.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER