Hi All,

I am assembling an inventory program for a small retail store. I have
a number of product catergories, each with a list of vendors or
brands. I have included a number of extra spaces for future vendors.
I have names set up for ranges to key to a specific vendor. Currently
I am using place fillers for names such as Acces40_ACC for the future
name of the Accessory Vendor. Is there a way to update the name
dynamically when the place holder is changed to an actual vendor name?

Example:

Acces40_ACC in shown in Cell DL2 with the placeholders for all of the
vendors model numbers in DL3:DL52. When I assigned the name to
DL2:DL52 using Insert / Name / Create assigning the top row as the
name, all is good but if I change the information in DL2 to ABCVending
the name remains Acces40_ACC and the formulas no longer work.

I need a method or formula to update or create a new name for the
range to be ABCVending so my formulas will continue to function.

Hope this makes any sense and thanks in adance for your assistance.

On Oct 7, 3:40*pm, Don wrote:
Hi All,

I am assembling an inventory program for a small retail store. *I have
a number of product catergories, each with a list of vendors or
brands. *I have included a number of extra spaces for future vendors.
I have names set up for ranges to key to a specific vendor. *Currently
I am using place fillers for names such as Acces40_ACC for the future
name of the Accessory Vendor. *Is there a way to update the name
dynamically when the place holder is changed to an actual vendor name?

Example:

Acces40_ACC in shown in Cell DL2 with the placeholders for all of the
vendors model numbers in DL3:DL52. *When I assigned the name to
DL2:DL52 using Insert / Name / Create assigning the top row as the
name, all is good but if I change the information in DL2 to ABCVending
the name remains Acces40_ACC and the formulas no longer work.

I need a method or formula to update or create a new name for the
range to be ABCVending so my formulas will continue to function.

Hope this makes any sense and thanks in adance for your assistance.

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."