|
|
|
|
#1
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" 
|
|
| Tags |
| cell references, drop down lists |
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode