Modify excel sheet
Budget: $10 – $30 USD
1. Do not to change sheet in a way that stops existing sheet or existing macro functionality.
2. (For sys 7 only) Highlight all 8th L in a row as pink.
3. Finish System 7 Col AH and AI as described a, b, c
Example See System 7 Colum AH and AI, Row 13-35 done by hand
a. Copy the (value) From Col AF to Colum AH (result)
b. Then Change all Colum AH, When Col AG = L, change Col AH (result) to - (negative)
c. Fill down the Running Balance equation in Colum AI ( if negative display w negative sign and dark red text. )
4. Apply step 3 a,b,c (above) to Systems 5, 5.1, 6, 6.1
2. (For sys 7 only) Highlight all 8th L in a row as pink.
3. Finish System 7 Col AH and AI as described a, b, c
Example See System 7 Colum AH and AI, Row 13-35 done by hand
a. Copy the (value) From Col AF to Colum AH (result)
b. Then Change all Colum AH, When Col AG = L, change Col AH (result) to - (negative)
c. Fill down the Running Balance equation in Colum AI ( if negative display w negative sign and dark red text. )
4. Apply step 3 a,b,c (above) to Systems 5, 5.1, 6, 6.1