P
Pat
In data/validation the source is =() but to access the source via another
book is it simply a matter of giving the full path name?
book is it simply a matter of giving the full path name?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
J
Jason Morin
P
Pat
Hello gentlemen,
Thank you for the link.
I have followed the example but I cannot seem to get it to work.
Here is an example of what I have done
Book1 contains the range called List
Book2 is where I want to use it in a validation list.
First I created a defined name (in Book2) called Book2List with the range
name
=Book1.xls!List
Then in Data/Validation the source is =Book2List
I am obviously overlooking something but I cannot put my finger on it.
Regards
Pat
Thank you for the link.
I have followed the example but I cannot seem to get it to work.
Here is an example of what I have done
Book1 contains the range called List
Book2 is where I want to use it in a validation list.
First I created a defined name (in Book2) called Book2List with the range
name
=Book1.xls!List
Then in Data/Validation the source is =Book2List
I am obviously overlooking something but I cannot put my finger on it.
Regards
Pat
D
Dave Peterson
I think you're going to have to follow those instructions one more time or post
back what you did and where it failed.
And just maybe, you skimmed over this line:
You can create a dynamic range that refers to a dynamic range in another (open)
workbook.
back what you did and where it failed.
And just maybe, you skimmed over this line:
You can create a dynamic range that refers to a dynamic range in another (open)
workbook.