March 2005 Actual Info vs March 2006 Plan Info
 

I have a large spreadsheet which needs to populate actual information for
March 2005 and Plan information for March 2006. (each month contains both
plan and actual information.

I'm using ADO to populate this spreadsheet, so I need range names which
properly differentiate between these two months.

My tentative solution is to use the range name 'MARCH1' {for the first
instance of March, March 2005}, and to use the range name 'MARCH2' {for the
second instance of March, March 2006}

I'll use a table to identify the range name for which I'm updating
actual information. and another table to identify the range names
for which i'm updating plan information.

I did not include the year in the range name, because next year, I'd want to
roll the year and not make any changes to the range name. {populate March
2006 Actual Information and populate March 2007 Plan Information}

I was wondering if anyone knew of a better way to do this.

Thanks in advance.