i want a vba code for combining sheets
with condition
sheet1 :
column a = 101 , 102 , 105, 108 , 115
column b = 5, 2 , 3 , 4 , 5
sheet2 :
column a = 101 , 102 , 103 , 104 , 105 , 106 , 107 , 108 , 109 ..........
column b = 10 , 20 , 30 , 40 , 20 , 35 , 30 , 15 , 0 .........
ans could be :
column b = (10+5)15 , (20+2)22 , 30 , 40 , (20+3)23 , 35 , 30 , 15 , (0+5)5 .........
with condition
sheet1 :
column a = 101 , 102 , 105, 108 , 115
column b = 5, 2 , 3 , 4 , 5
sheet2 :
column a = 101 , 102 , 103 , 104 , 105 , 106 , 107 , 108 , 109 ..........
column b = 10 , 20 , 30 , 40 , 20 , 35 , 30 , 15 , 0 .........
ans could be :
column b = (10+5)15 , (20+2)22 , 30 , 40 , (20+3)23 , 35 , 30 , 15 , (0+5)5 .........