By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Validating List from Different Workbook

P: 15

Basically I have 3 workbooks (A, B and C)
Workbook A is used to retrieve all the information
Workbook B contains a number of Lists used in workbook A (including a list of suppliers)
Workbook C contains a list of items available from suppliers (Each supplier is on a separate worksheet)

On Workbook A I have 2 Dropdown Boxs, Initially I named the supplier list in Workbook B as "SupplierList". In Workbook A, In the validation options I Choose List and put "SupplierList" into the source field. I then got an error msg saying I could not validate list found in a different workbook.
To get round this I Defined a New Name in workbook A as "supplier" this then referenced the list in Workbook B

Name in Workbook = Suppliers
Refers To: = [workbookB.xls]!SupplierList

This work Fine and allows me to reference a different workbook using list in the validation. (this dropdown box is in cell a1)

Then I wanted to display the list of items available from the supplier which is selected in the first dropdownbox in workbook A in a different dropdown box. Again I followed the same principles.
I Defined the names as the supplier name. So i Select supplierA in the first dropdown box. In the 2nd dropdown box in the validation option, I set Allow to List and source: =Indirect ($A$1)
However I get an error message saying there is a source error.

If I change Indirect($A$1) to =Supplier A, in the validation source it refernces the appropriate list in workbook C,

How can i get the list in box 2 to depend on the choice in box 1 and call results from a different woorkbook?


Jan 25 '08 #1
Share this Question
Share on Google+
1 Reply

daniel aristidou
P: 491
Im not quite sure on what you want to do....but sounds like its related to cascade updating comboboxes........... view this article and reply if it didn't help or you need further assistance with it.....
Jan 31 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.