This seems to add another reference as you add more data. I am looking to
automatically index to the next column in the referenced row when new data is
input. This will have the cell referencing the most current data entered in
the entry row. If my columns are set up as the months and the data points
are the rows. as I enter in the data for March, the cell on the display that
was pointing to February will advance one column to now display March data.
Does that make more sense?

"T. Valko" wrote:

Sounds like you need dynamic ranges:

http://contextures.com/xlNames01.html#Dynamic

Biff

"Balzyone" wrote in message
...
I have created a workbook for our metric dashboard reporting. It is an
extensive file that has a tab that is just for the display board, a tab
for
raw data entry/ calculations, and several tabs for the drill down charts
that
go to the display tab. I have the cells set up to change color by what
the
metric calculations are by using conditional formating. Each month when I
update the entry tab, I have to go to the display tab and change each data
reference cell to reflect the next column for that data point to reflect
the
new month. Is there a way to make it update to the new month column for
the
cells that refer to the other tab?