Forum Discussion
Workbook Comparison
You don't provide any examples of the data, so it is difficult to provide help.
The free 'Professional_Compare' workbook is worth a try.
It makes a cell to cell comparison between two worksheets,
or
makes a row comparison between two worksheets.
Your should try the row comparison.
It is easy to use.
Download from OneDrive...
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
'---
Nothing Left To Lose
Nothing_Left_to_Lose Being the type of Data I have, I cannot share it as it is private information. I did, however mention that it was document titles, with the name of the folder they were saved in, and the patient name. Those are the 3 pertinent fields of interest. If you could tell me what else you would need to give examples I could tell you.
If you can copy and paste the new set of multiple worksheets into a new single worksheet and do the same for the previous set of worksheets, then the 'Professional_Compare' workbook might be able to do the job.
What I don't understand is why/how the "name of the folder they were saved in" is included as a pertinent column title?
'---
Nothing Left To Lose
- Hey there, due to the information I am working with, and why we are running this comparison, all 3 columns of data is pertinent. I need to know all 3 items together (in a row = a match) and then if it is present on both Workbook A and B.
I have tried copy/pasting but it is actually 1,000,000 lines of data and to do that continues to crash both excel and the computer. Even after adding more RAM to our computer. It is a massive amount of data.
