HELP.. Is it possibe???

[nowhereman]

I have a workbook which i use to select material items needed for a
project and then i enter quantity and i get total cost returned. i have
a "material cost" worksheet which is linked to all the various projects.

most of the fields i already have set up use a drop down list (data
validation) to select from a list of materials. then i use vlookup or
match with a ton of different "named cells" as the variables.

has worked great for a long time so i have quite a collection of
different projects created off this template...... my forsight was
shortsighted when i first set up the "material cost" template.

So i now have to update it to make it larger and hold more data..... so
now all my "named cell references point to the wrong selection set. i
have reset all the names on the template, but that does not transfer to
all my copies. is there anyway to import the Named cell definitions
from one workgroup to another.

TIA for any help you have to offer\

NWM

 

[Guest]

I'm thinking it is just as easy to send a new template and have them delete
the old one.

 

[Jim Rech]

I'm not sure I follow you completely, and this is 'quick and dirty' in any
case, but this macro looks at every name in the active workbook and changes
it to refer to the same thing it refers to another workbook (Book1.xls which
you'll wan to change of course). Hope this helps.


Sub ChgNameRefersTo()
Dim Nm As Name
Dim Def As String
Dim MasterWB As Workbook
Set MasterWB = Workbooks("Book1.xls")
On Error GoTo NoName
For Each Nm In Names
Def = MasterWB.Names(Nm.Name)
Nm.RefersTo = Def
NextName:
Next
Exit Sub
NoName:
Resume NextName
End Sub