View Single Post
 
Old 05-01-2012, 03:34 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote