This article from Jon Peltier should help get you started. It applies to
dynamic charting, but the concept is the same.

http://pubs.logicalexpressions.com/P...cle.asp?ID=246
--
HTH,
Barb Reinhardt



"Nelson B." wrote:

I need some help making some of my reports more automated. What I'm trying
to accomplish is being able to fill in a reference cell for the current
month, and have ranges in varying functions adjust to include the new month.
This way I can enter the new data and not worry about having to go and adjust
every formula to include it. For example, if January's data is in cell C4
and I want to sum the data for January thru August I'd like to be able to
write the formula to SUM(C4:C("current month")). I've tried doing this
various ways, but have been unsuccessful.

Thanks for any suggestions.