• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparison of 2 excel workbooks

dereynek
You sent .xlsx-file ... it do not have any code!
That would be 'the mistake'.
If You would do same procedure with many files then
You could make 'mappinglist's for each comparsion and after that ... press the button and ... get the results.
 
vletm said:
dereynek
You sent .xlsx-file ... it do not have any code!
That would be 'the mistake'.
If You would do same procedure with many files then
You could make 'mappinglist's for each comparsion and after that ... press the button and ... get the results.
Click to expand...
Oh, sorry that was because i wanted to show the updated workbooks and sheets. Here is the wb, i have attached the code i initially tried out as well.
 

Attachments

  • Books-Raw Listing.xlsx
    8.8 KB · Views: 2
  • Raw Listing.xlsx
    8.8 KB · Views: 2
  • MASTERFILE.xlsm
    26.2 KB · Views: 2
dereynek
Seems that You have skipped all my hints ... hmm?
I would do it this way ...
Note! ALL Your written data have to be CORRECT!
You can add as many those 'sets' as You need.
 

Attachments

  • MASTERFILE.xlsb
    24.2 KB · Views: 5
Hello!! this works perfectly!!! I’ve managed to implement this for my other spreadsheets as well. Just wanted to say thanks for taking the time and effort to help out :)
 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top