Hello there!
I want to know If I can complete this with macro, and if so, how?
I am pretty new into all this mess.
Lets Say
I have a J table with date, I table with devliering person, and K with amount.
I want a macro that does check if the J(date) is the same, and if it is, then check if the I(delivering) has the same value, and if the K(amount) is the same, then
I want it to leave one row as correct amount like 27 for example, and all the others 27 I want to have 0 value.
Also after every date swap like 17 jan to 18 jan, I'd love to have 3 rows blank for my own calc's
Is it possible to achieve ?
Example
I J K
DAD 18 sie 17 11
SDA 18 sie 17 14
ABC 18 sie 17 50
ABC 18 sie 17 50
ABC 18 sie 17 50
ABC 18 sie 17 50
Desired
I J K
DAD 18 sie 17 11
SDA 18 sie 17 14
ABC 18 sie 17 50
ABC 18 sie 17 0
ABC 18 sie 17 0
ABC 18 sie 17 0
Bookmarks