Hi,

Excel -- Data Validation -- Create Dependent Lists.

Use this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu


"Balzyone" wrote:

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?