Good Day

I am new to VB and are starting to use VB with excel.

I have two different data sheets and want to compare the 2 and wants VB to give the results were the data in one is not in the other and vice versa.

As soon as have that done, I want to use this VB code on other 2 sets of data, but the ranges will differ.

So each time the ranges must be update automatic.

Example: Sheet1 contains data from company 1
Sheet2 contains data from company 2.

It is intercompanies and now if want to make sure that all transaction between the intercompanies are recored and if not, a report in a new sheet must give the transaction that are not recored and in which company.

I hope that will be enough information. let me know if you need more.