"Create a drop-down list from a range of cells"
Dear
By using the help level I have created dropdown list in one work book. I want to use the same list in another workbook by linking the same way (insert, name, define, refersto .......) as explained in help level but it is not working. Please help me. |
"Create a drop-down list from a range of cells"
It can be done, but it needs a bit of work.
Normally, you would use a named range in the DV type. You still do that but you cannot use the name in the second workbook. You need to create an additional named range in the first workbook that refersto the name in the second workbook, and use that in the DV. As an example, A1:A10 on Sheet1 in Book2. Create a name called rngBook2 with Refersto =Sheet1!A1:A10. Then in Boook1, create another name called say rngBook1, refersto =[Book2]Sheet1!rngBook2. Use rngBook1 in the DV custome type in Book1. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "DILNAVAS" wrote in message ... Dear By using the help level I have created dropdown list in one work book. I want to use the same list in another workbook by linking the same way (insert, name, define, refersto .......) as explained in help level but it is not working. Please help me. |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com