morning all.
this is a little complicated, i'll explain the situation.
i have a workbook, two worksheets, one for 2005, one for 2004.
there are 13 columns in each sheet, one column in each sheet relates to an
amount, and another column relates to a date.
so far i have managed to combine the sheets to sum the amount column and if
it reaches a certain amount, show a message to that effect.
the problem is that the way it is currently set up it takes amounts from
2004 and adds them to 2005 ytd.
what i really would like to be able to do is have a rolling twelve months.
i know that i need to link the date in there somewhere specifically in
mm/yyyy format.
if anybody has any suggestions on the code that i would use to do this, they
would be greatly appreciated.
thanks

mike