In SheetA , Range(D4:D43) contains dates. Column E through N contain
data.

I need a macro that will do the following:
1. Go through the date column, if the month and year of each date in
Range(D4:D43)is same as the current month and current year, then for
each column in the data range from column E through N, SUM up all the
corresponding data and put the total in row 44 of the column.

(Simply put - calculate the month-to-date into row 44 for the data in
columns E through N based on the dates in column D)

2. THEN offset the date range(D4:D43) 43 ROWS DOWN and repeat the same
calculation for its data range in columns E through N as above.
--It should continue looping down the sheet until the offset date range
in column D contains no dates.

Any help would be appreciated. I have fought with this so by myself for
so long I am getting a headache. thanks.

Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!