I have an Excel file that contains multiple pages. All of these pages
require a range of data that includes the most recent 10 years plus prior
years. For example, in cell A1, I enter "Prior Years". In A2, I enter 1995,
in A3, 1996, in A4, 1997, etc. I want to be able to build this data range on
one page and then on subsequent pages use this range name so I only have to
change the dates in one location. I have created the initial range of data
and assigned it a range name. When I go to the other pages, I select the
appropriate cell and type '=RangeName' (not including the tick marks. When I
do that, I don't get the expected dates. Instead it displays, "=RangeName".
What do I need to do to get the desired results?