Posted to microsoft.public.excel.misc

ExcelUser777

Posts: n/a

Updating Range Names

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Protecting Range Names	Frederick Chow	Excel Discussion (Misc queries)	4	March 8th 06 12:09 PM
Range Names	Wes	Excel Worksheet Functions	2	June 27th 05 11:36 PM
Excel Range Names	trainer2000	Excel Discussion (Misc queries)	1	May 20th 05 08:42 PM
How do I use Range Names listed in a VLookup table in a formula?	Essbasedvlpr32	Excel Worksheet Functions	3	December 15th 04 10:11 PM
Range Names	wal50	Excel Worksheet Functions	3	November 27th 04 12:49 AM

All times are GMT +1. The time now is 08:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us