ramzillion
New Member
Will greatly appreciate your help with this please. This is part of a much larger & in-production automation, but we are now stuck with this issue now.
Scenario: Two different excel workbooks A & B. Inside A, we have named range X. Inside B, we have a named range Y that is linked to X in A.
Problem: We want to define a dropdown list in B using Y. It refuses to accept.
Inside dropdown, list, we have tried:
=indirect(Y)
=indirect(A.xls!X)
=Y
Y
indirect(Y)
all five above give errors.
Pls help!
Scenario: Two different excel workbooks A & B. Inside A, we have named range X. Inside B, we have a named range Y that is linked to X in A.
Problem: We want to define a dropdown list in B using Y. It refuses to accept.
Inside dropdown, list, we have tried:
=indirect(Y)
=indirect(A.xls!X)
=Y
Y
indirect(Y)
all five above give errors.
Pls help!