Awkward dropdown list generation

copwriter · #1 06-28-2014, 05:01 PM

Quote:

Originally Posted by whatsup

But what you can do, is fetching the data from the closed workbook to a sheet of your workbook you are working with by ordninary formulas. This range then you can use for your dropdown, and excel will accept this.

With your extern references in your workbook, excel will ask on opening, if the references shall be updated or not.

Can you give me an example of one of these formulas?

whatsup · #2 06-28-2014, 05:59 PM

Well, I don't know what your workbook "MasterList.xlsx" looks like, for example:
While both workbooks are open enter in a cell:
=[MasterList.xlsx]Sheet1!A1
and copy the formula as far as you expect having data in "MasterList.xlsx"

When closing "MasterList.xlsx" excel will extend the formula with the complete path to "MasterList.xlsx"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dropdown list, Macro	shield5	Excel Programming	7	10-27-2013 01:51 AM
VBA: How to place dropdown list next to text	YigalB	Word VBA	0	08-11-2013 01:48 PM
block selection in dropdown list	Intruder	Excel	2	01-10-2013 10:20 AM
dropdown list for documents	r_p_t_0	Word	2	12-18-2012 05:55 AM
Dropdown list of email addresses	J Partridge	Outlook	1	01-13-2011 06:37 AM