hello me again.
i've had a look at previous posts but am still a bit stuck!

i have a workbook.
there are two worksheets.
one is for 2004 and one is for 2005, soon I will have 2005 and 2006, but we
can talk about that later.
there are various columns.
i am particularly looking at two... date column and amount column.
the date column does not run sequentially, the dates are ad hoc, eg, they do
not run 21/22/23 it may be 20/22/23/27.
i have a macro which will add the values in the amount columns from both
sheets.
but what i would like it to do is...
look at today's date, and find the corresponding date in the 2004 sheet and
add everything from that date on, so it is effectively a 12 month rolling
period.
any suggestions would be greatly appreciated.
thanks in advance

mike