if the formula works now all you ned to do is set up your data validation
list or combo box so that your choice appears in A! your formula will work
just the same
--
paul
remove nospam for email addy!



"ExcelUser777" wrote:

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