Please, help me to show some data from closed workbook by using dynamic named range.
Please Login or Register to view this content.
Please, help me to show some data from closed workbook by using dynamic named range.
Please Login or Register to view this content.
Last edited by putritersenyum; 08-30-2016 at 10:38 AM.
What type of data is it? Text? Numbers? Could be both? Something else?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
the type of data is number and the some names are general (text, date, number)
@Tony Valko
It doesn't work for me.
How about the formula below? If the reference file is closed the result is #VALUE, but if the reference file is open the result is the data on MYDATA.
MYDATA = name range on closed reference filePlease Login or Register to view this content.
NO = name range on closed reference file
Last edited by putritersenyum; 08-30-2016 at 11:05 AM.
Sorry, I'm out of suggestions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks