VBA Code to Compare Two Worksheets and display the columns with changes.

Hi Pals,

I want to write VBA code where I want to compare two different worksheets and find all those columns from new Worksheet where data from the column has changed compared to last worksheet. I am going to compare current months worksheet with earlier months worksheet.

Thanks.

Will the data always be in the same ROWS, between the two worksheets?
To clarify, will row number 100 on worksheet #1 always be the same record as row number 100 on worksheet #2?

Do you want the differences highlighted on one of the worksheets, or all rows that are different written to a new worksheet?

Approximately how may rows and columns do you have?

First of all I want to thank you for replying on my post.

I will post the exact requirement in few hours there is change in the requirement.

I request you to check this post after few hours.

Thanks.