Dropdown box linked to another workbook
Hi, does anyone know how to create a dropdown box that will list the contents
of a column in another workbook? Basically, I have two workbooks. One is a sales register that records the serial number of a marketing campaign that generated the sale. The serial numbers are 8 digits long and located in the second workbook which is a marketing campaign register. So I need the name of all current marketing campaigns in the marketing register to be displayed in the dropdown list but the serial number of the selected campaign to be inserted into the cell in the sales register. Hope you understand that, but I would appreciate any help. Thanks Simon |
Dropdown box linked to another workbook
If the other workbook is open, you can use the technique described he
http://www.contextures.com/xlDataVal05.html Pieman wrote: Hi, does anyone know how to create a dropdown box that will list the contents of a column in another workbook? Basically, I have two workbooks. One is a sales register that records the serial number of a marketing campaign that generated the sale. The serial numbers are 8 digits long and located in the second workbook which is a marketing campaign register. So I need the name of all current marketing campaigns in the marketing register to be displayed in the dropdown list but the serial number of the selected campaign to be inserted into the cell in the sales register. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Dropdown box linked to another workbook
Simon,
Maybe a solution; http://www.contextures.com/xlDataVal05.html Gr, Rody "Pieman" schreef in bericht ... Hi, does anyone know how to create a dropdown box that will list the contents of a column in another workbook? Basically, I have two workbooks. One is a sales register that records the serial number of a marketing campaign that generated the sale. The serial numbers are 8 digits long and located in the second workbook which is a marketing campaign register. So I need the name of all current marketing campaigns in the marketing register to be displayed in the dropdown list but the serial number of the selected campaign to be inserted into the cell in the sales register. Hope you understand that, but I would appreciate any help. Thanks Simon |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com