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

To the best of my knowledge you "jumped too far" because there no macro is
needed while a simple formula can achieve your request:
http://img515.imageshack.us/img515/6664/nonameln.png
Micky


"pol" wrote:

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