P
pol
Hi all,
I have an excel with the following structure. I wat the sum of the amount
just near to the next column of the 'Amount'. I cannot use subtotal because
subtotal will not work here. I kindly request ur advice to write a macros
using
For loop
if the row is blank <blank row> then find the sum of the previous row
which is not blank and put that sum in next column.
Catagory Group Amount
-------------------------------------------------
A A group 12.70
-3.20
1.00 10.50
<blank row>
B A Group 12.20
-3.20
1.00 10.00
<blank row>
A A Group 12.20
-3.20
1.00 10.00
Please help
I have an excel with the following structure. I wat the sum of the amount
just near to the next column of the 'Amount'. I cannot use subtotal because
subtotal will not work here. I kindly request ur advice to write a macros
using
For loop
if the row is blank <blank row> then find the sum of the previous row
which is not blank and put that sum in next column.
Catagory Group Amount
-------------------------------------------------
A A group 12.70
-3.20
1.00 10.50
<blank row>
B A Group 12.20
-3.20
1.00 10.00
<blank row>
A A Group 12.20
-3.20
1.00 10.00
Please help