Dynamic Names
 

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.