Hi Experts,

I had this request previously, where I wanted both way comparison of 2 excel workbooks.
@jindon
has a good solution here in this link
https://www.excelforum.com/excel-pro...el-sheets.html

Can this be modified / same features with the following
1. Ignore the formats.
2. Ignore the spaces at the end of the line.
3. Is it possible to ignore the number format '001' in one sheet to just '1' in another sheet ?
4. Instead of user provided name, can the script read the default 1st sheet whatever name please

Thanks in Advance