drwat,

THank you for updating your thread title. As for where to enter the dynamic named range formula, in Excel 2007 go to the Formulas Tab and click Name Manager