Hi,
i have a table (Example Table)in Access with named range name column and ServiceModel in second column, something like this:
Named Range:
Var_NR1
ServoceModel:
ServiceModel1
I am connecting from Excel to Access and using Access' tables as source for dynamic tables in Excel.
And now it is possible to refer within name manager to Named range from dynamic table?
I mean something like this in name manager--> name: Var_NR1, RefersTo: VLookup (Var_NR1.name,Indirect("Example Table"),2,0)
Var_NR1.name is refer to named range name?
Please help,
best
Jacek
Bookmarks