Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- Windows
In my excel sheet I have Demand, collection and balance rows. I have some value in I3 of balance row the value of I3 is depend upon the value of U1, if the value of i3 is less then U1 then, i3 = T1 and after that value of U1 should be U1-T1 & i3 should be zero.
example -
I have value 40 in my I3, U1=500 hence the value of i3 is less then U1 so i3=T1 so T1 should be 40 & U1 should be 460 & i3 should be zero.
I want a VBA macro for this.
Before macro
After macro I want like this
example -
I have value 40 in my I3, U1=500 hence the value of i3 is less then U1 so i3=T1 so T1 should be 40 & U1 should be 460 & i3 should be zero.
I want a VBA macro for this.
Before macro
After macro I want like this
