Compare 2 different excel sheets

[coolnidhi29]

Hi everyone,

I need your help to create a VB program in excel. Here goes the description.

Excel Sheet A is a comment sheet which contains ‘n’ number of consolidated comments by the reviewer on many of the previous technical reports.

Excel Sheet B is a prepared technical report.

I need your help to write a code to check whether all the comments in Sheet A are incorporated in Sheet B. If not the mistake should be highlighted.

Request you to help me in this.

Thanks.

[YasserKhalil]

Cross-Post at this link
http://www.vbaexpress.com/forum/show...t-excel-sheets