-
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 |
|
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules