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

May7 Posts 1 Registration date Friday August 21, 2015 Status Member Last seen August 21, 2015 - Aug 21, 2015 at 03:56 AM
 MAY7 - Aug 25, 2015 at 01:31 AM
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.
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.

1 response

xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,833
Aug 24, 2015 at 04:43 PM
I would think Bosch could afford a programmer or two.
Yaa but its not up to me, and I am not a programmer. I am at basic stage of VBA.
I would appreciate your help.