Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two linked dropdown list | Excel Discussion (Misc queries) | |||
How do I set up a form with a dropdown linked to another sheet? | Setting up and Configuration of Excel | |||
pulling color from cell of workbook to another linked workbook | Excel Discussion (Misc queries) | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Change sheet name on linked cell by dropdown box | Excel Worksheet Functions |