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

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

What version of Excel are you guys using?

My version, 2002, won't accept range names that are numeric. 0601,0602 etc.
Invalid name!

Biff

"paul" wrote in message
...
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

Biff, Paul


I have Excel version 2002 SP3
Do you know of any other way to link what the drop down list shows in
cell A1 to a formulas elsewhere on the spreadsheets?



Thanks,
ExcelUser777

I misinterpreted your question.I thought you had the selection of the cells
already working and merely wanted to change from a typed input to a drop dowm
--
paul
remove nospam for email addy!



"ExcelUser777" wrote:

Biff, Paul


I have Excel version 2002 SP3
Do you know of any other way to link what the drop down list shows in
cell A1 to a formulas elsewhere on the spreadsheets?



Thanks,
ExcelUser777