Menu
Ask a question Report

Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme

Posts
1
Registration date
Monday February 11, 2019
Status
Member
Last seen
February 11, 2019
 - - Latest reply: ac3mark
Posts
12936
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
September 3, 2019
 - Feb 11, 2019 at 11:18 AM
Programming Ask a question Report
Hello,

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

Thanks & Regards
Suresh
See more 

1 reply

Report Respond to ac3mark
Posts
12936
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
September 3, 2019
 1342
0
Thank you
If you are stuck in writing the code, I will assist. If you wish to remain patient and wait for others to attempt to write your solution, feel free to wait.

I encorage you to post your code here.
Respond to ac3mark
Reply Ask a question