Macro for group total

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top