Hi
I am completely new to VBA.
I have a in sheet1 in A and B column employees ID and in C a sale.
In A I have always an ID, in B i can have zero or an ID, in C a sale
A_______B______C
81021___0_______500
81032___81044___2000
81048 __0_______1450
For each row
If the value in B = 0 i don't have to do anything
I b <> 0 i have to divide the value of C by 2, write 0 in B and append at the end of the list in A the ID that i have in B and enter the value/2 in C
From the above example the result will be:
A B C
81021__0 ___500
81032__0 __1000
81048__0 __1450
81044__0 __1000
Thanks
Bookmarks