Wafee
11-17-2020, 04:18 AM
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
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