#1
|
|||
|
|||
drop down list from external data source Excel 2007?
drop down lists can easily made by means of named ranges inside the same workbook/sheet. Can I use this option also with data in an external data sheet ? The source field in the data validation tool won't allow me to use external references is this correct ? |
#2
|
|||
|
|||
Hi Have a look at this link which may help you: http://blog.contextures.com/archives...erent-workbook Good Luck Tony
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
vba change external data source | excelledsoftware | Excel Programming | 1 | 07-17-2012 04:22 AM |
How can I revise Excel data source in merge? | navysalad | Mail Merge | 6 | 01-07-2012 06:50 PM |
Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
Conditional data validation (list drop-down) | click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
Help w/ external data | bellest | Excel | 0 | 11-11-2005 12:51 PM |