Could you please help me to provide me the macro for below conditions.
Macro to compare two excel sheets(Jan & Feb) , highlight the difference.
In Jan sheet we have added the extra column as comments, so this comments column need to be copied in the Feb sheet
In Feb sheet extra records comments column should be blank as these are the new records.
The number of columns may not be equal and it can vary each time. So, we need to find the range of columns and provide the output