PERSONAL.XLSB range A1:A3 contains = Apple, Mango, Banana > define name = fruits
How to make the name can be used on every active workbook?
PERSONAL.XLSB range A1:A3 contains = Apple, Mango, Banana > define name = fruits
How to make the name can be used on every active workbook?
1) Create the named range in the PERSONAL.XLSB
2) In your external workbook, create a named range that refers to the PERSONAL named range:
Name: Fruits
RefersTo: =Personal.xlsb!Fruits
So, it's active all the time, but to actually use it in any one workbook, you have to create the dynamic link. But once done, if you edit the source list in the PERSONAL file, that change flows to all the other workbooks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JBeaucaire,
thanks so much
Last edited by putritersenyum; 03-21-2016 at 08:24 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks