how to consolidate list of qty under within date columns
 

Hi all,

I'm a novice on excel programming can someone to help me that.

The file format as follow, I would like to summaries

Month-A Month-B
Cost Date1 Date2 Date3 Cost Date1 Date2 Date3 Date4
0.1 4 0 3 1.4 2 23 42 12
1.2 10 1 2 2.1 11 10 2 2


Month-X showing month of year.
Cost contain cost of product
Date1.... showing the xth of Month-X column
contain qty of each date.

Are there any techinque can sum the column of date using Excel VB !

Thanks very much for any guys can give hand of it.