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

[Closed]
Report
Posts
1
Registration date
Friday August 21, 2015
Status
Member
Last seen
August 21, 2015
-
 MAY7 -
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.

1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,910
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.