Vba button Comparison data between two file or two tabs

[Thainguyen]

Hi Alan,
Thank you for the code. it is working out excellence. That is exactly what i am looking for. But there is minor change.
1. changed the layout of the template and the name of tabs.
2. Can your code only compare column B,C, E, F and G. I don't need it go through A and D.
3. the tab for result. Can we just showing the data different instead of all the data because some time we have couple hundred of rows and it will messy to show everything.
4. If i am deleted some row on sheet2 (NEW). There is notification for that. It should showing on the result as deleted. Or something like part ABC << >> empty.

Please check our email. i have sent you the sample template but with the new layout