drop down list
I am trying to create a drop down list that references another workbook. I
found the instructions on how to do this in the Excel help guide. However, when i follow the directions to do so, i receive an error that says you cannot reference another workbook when validating data. can anyone help me with this? |
drop down list
under data validation choose list a formula similar to this will work: =INDIRECT("[Book3]Sheet1!$A$1:$A$19") -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=563757 |
drop down list
there isnt a way to do it without having to have the other file open is there?
"MDubbelboer" wrote: under data validation choose list a formula similar to this will work: =INDIRECT("[Book3]Sheet1!$A$1:$A$19") -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=563757 |
drop down list
not that I know of. you can create a macro to open the second sheet and hide it as the first is opened, but that would involve the user having to enable macros everytime they opened the sheet. -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=563757 |
All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com