VBA code to compare and update column
Hi, Can someone help me with a VBA code for the below I tried but couldn't get at anything that works. Thank you inadvance.
below is sample data list which is present in sheet1.
| Name1 - Column A |
Name2 - Column B |
| A |
|
| A |
1 |
| A |
2 |
| A |
3 |
| A |
4 |
| B |
|
| B |
3 |
| B |
2 |
| B |
4 |
| C |
|
| C |
5 |
| C |
6 |
| Grand Total |
|
below is sample data list which is present in sheet2.
| Name1 - Column A |
Name2 - Column B |
| A |
|
| A |
1 |
| A |
2 |
| A |
3 |
| A |
4 |
| B |
|
| B |
3 |
| B |
2 |
| B |
1 |
| B |
4 |
| C |
|
| C |
5 |
| C |
6 |
| D |
|
| D |
7 |
| Grand Total |
|
Code has to compare column A data from both sheets and if anything new is found then that needs to be added above the grand total in column A (In this case it is name D). (any new data will be present in sheet2 hence that needs to be added to sheet1)
then it has to compare combnation of colum A and Column B data in the both sheets and if any combination is not present then that needs to added below the last occurance of respective name1 row.(In this case we have B-1 which is not present in the output and has been added to 11th row as 10th row is last occurnce of B. similarly D-7 has been added to 16th row.).
below is the expected output that wil be present in sheet1.
| Name1 - Column A |
Name2 - Column B |
| A |
|
| A |
1 |
| A |
2 |
| A |
3 |
| A |
4 |
| B |
|
| B |
3 |
| B |
2 |
| B |
4 |
| B |
1 |
| C |
|
| C |
5 |
| C |
6 |
| D |
|
| D |
7 |
| Grand Total |
|
