P
pol
Hi all, I have an excel with the following format. I have to find out
subtotal of the each date column. The empty date column should be considered
under the group of previous column having date. Please help. I want to write
a macros to get group breakeup total
Date Amount
A1 B1 C1
01.01.2010 2000 Cumi.Sum
-200
-300
-1500 0.00
10.01.2010 500
-300
-200 0.00
20.01.2010 700
-200 500.00
30.01.2010 400
-400 0.00
With thanks and regards
subtotal of the each date column. The empty date column should be considered
under the group of previous column having date. Please help. I want to write
a macros to get group breakeup total
Date Amount
A1 B1 C1
01.01.2010 2000 Cumi.Sum
-200
-300
-1500 0.00
10.01.2010 500
-300
-200 0.00
20.01.2010 700
-200 500.00
30.01.2010 400
-400 0.00
With thanks and regards