Dynamic Names

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

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.
 
Delete the name. Reassign the name. Use cntl-F and Find/Replace the
old name with the new name.
 
Back
Top