Hi cjaye,
Even without data for the dates, you can probably use formulae alone to retrieve the data for the latest month. If you can post a sample workbook with a couple of months' data, I'll take a look an see what might be possible. That will also be helpful if a macro-based solution is required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|