Hello,

I have a named range in the formula below..... BS_UM_0606....


=ROUND(SUMIF(BS_Um_Code,'Summary BS'!$A10,BS_Um_0606),0)


I have other named ranges for example 0607

My goal is to enter 0607 in a cell and have the 0606 update to 0607

Is there a way to update a range name by typing in a new range name in
a cell?




Thanks,
ExcelUser777