Roger Govier has taken the pain out of creating dynamic ranges, by creating a macro to automatically create the ranges for you.

When you run the macro in Excel, it creates a series of names for each of the column headings on the sheet. In addition to the Names for the column ranges, 3 extra [...]