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.