Hello,

I have a list of named ranges 0607 equals fiscal year 2006 period 7

I want to create a drop down list with the following named ranges.
Each range pertains to a month

0601,0602,0603,0604,0605,0606,0607,0608,0609,0610, 0611,0612

Right now I punch in cell A1 0607 and all 300 or some odd cells are
updated with period 0607 data, that is all the sumif formulas that
reference cell A1 are updated


I want the user to be able to use a drop down list and choose 0608 and
have all the formulas that are referenced to A1 update all the formulas
on the spreadsheet

That is I want to put the drop down box in A1 and whatever is choosen
by the user will update the cells that reference cell A1

=SUMIF(IS_UM_Code,$A17,INDIRECT(A1))

What is the the best way to do this?

Thanks,
ExcelUser777