I'm trying to compare the contents of two folders by importing the filenames into Excel. I have one spreadsheet which has 'E-ISBN' and 'Book Name'
In another spreadsheet I have imported the filenames of the contents of two folders. One containing the E-Books named using the E-ISBN and another folder of covers, again anmed using the E-ISBN
However these two folders do not match. Some E-books are missing from the E-Books folder. What I need is for the 'Book Name' from the first spreadsheet to be inserted in the third column of the second spreadsheet in the correct row.
Spreadsheet One
E-ISBN Book Name
100 Book1
101 Book2
102 Book3
Spreadsheet Two
E-ISBN Cover Book Name
100 100 (From Spreadsheet One)
101 101 (From Spreadsheet One)
102 102 (From Spreadsheet One)
(There should be tabs separating the above)
In another spreadsheet I have imported the filenames of the contents of two folders. One containing the E-Books named using the E-ISBN and another folder of covers, again anmed using the E-ISBN
However these two folders do not match. Some E-books are missing from the E-Books folder. What I need is for the 'Book Name' from the first spreadsheet to be inserted in the third column of the second spreadsheet in the correct row.
Spreadsheet One
E-ISBN Book Name
100 Book1
101 Book2
102 Book3
Spreadsheet Two
E-ISBN Cover Book Name
100 100 (From Spreadsheet One)
101 101 (From Spreadsheet One)
102 102 (From Spreadsheet One)
(There should be tabs separating the above)
Last edited:
