I need a code in VB to compare 2 excel files.
Requirement: There will be 2 files, Base file and Actual File.
Code should compare Actual file with Base file and if there is descriprncy it should highlight in red colour in Actual file and it shoul put comment for that cell in Actual file. Comment should contain corresponding value in Base file.
Please help me.. This is first assignment in company.