Search,compare,update,indicate data in excel sheet (macros VBA)

May - Aug 20, 2015 at 09:48 AM
search, compare, update and indicate data in excel sheet with macros VBA
Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. Another targeted sheet to be completed with using VBA which content same 10-15 thousands row but selected 25- 30 columns.
Following operation must be done to get targeted sheet.
  • Button for performing below operation
  • Searching unique ID number from sheet2 to core sheet1.
  • Compare
  • If any change than update in sheet2
  • Color the update
  • Indicate the row which is updated

I will be really happy if some one help me to find out solution for the problem as early as possible.