Hi Everone
Hope all are well.
I search many forums to find something but nothing seems to be similar to the problem which I describe below, hope someone helps me with a solution.
I have two worksheets named 1 and 2, Sheet 2 is the source data sheet and sheet 1 is the destination datasheet.
In sheet 1
SL | ID | Name | --- | Contact Person | Class | Result |
1 | 111 | Martin | Justin | O | 156 | |
2 | 112 | Jhon | Rubel | A | 160 | |
3 | 113 | Albert | Rose | C | 190 |
And In Sheet 2
ID | Contact Person | Class | Result |
112 | Rubel | A | 180 |
113 | Rose | C | 190 |
Now the question is after putting data in sheet 2, A command button will be clicked then the row checked in sheet 1 to the last value for a matching (ID, Contact Person & Class) if any row matched with these three conditions (ID, Contact Person & Class) found then the matched Result Column data update and unmatched data will be same as it is.
Like in sheet 1 & sheet 2 ID 112 & 113 matched, but only SL 2 result value will be updated as (ID, Contact Person & Class) matched and the result value is different but
SL 3 will be unchanged as it is the same as before. and
SL1 will remain the same too.
Hope someone helps me to ease the difficulties of value update.
Thanks in Advance