Sure, I use to recommend this link, it has good examples and explanations:
http://www.ozgrid.com/Excel/DynamicRanges.htm
Miguel.
"thewiz1972" wrote:
Very cool. Perhaps you could answer one more question for me.
In Sheet2 I will be adding new bills from time to time so is there a
way to properly reference this dynamic range in the formula you've
provided?
Thanks,
-Mark