Forum Discussion
Workbook Comparison
I need help, as I have exhausted all the options I know. Workbook A is from Oct. Workbook B is from Nov. Each workbook is data exported from our EHR system, and I could not choose how it was...
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.
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.