About Us

kiln

Wow, hits the nail on the head! Thanks!

In article ,
says...
Hi
try the following:
- create a defined name for your list (goto 'Insert - Name - Define')
- use this name as data source within the data validation dialog

also have a look at
http://www.contextures.com/xlDataVal05.html

--
Regards
Frank Kabel
Frankfurt, Germany

"kiln" schrieb im Newsbeitrag
om...
This is such a terrible limitation... isn't there any way around it?
I
have a list that could be used on many worksheets, and if I have to
copy/paste link it to all of those pages, it'll be a maint headache.
I'm
using the list(s) for Data/Validation lookups.

Thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using one source list for two depends drop-down list	Grand Seigneur	Excel Discussion (Misc queries)	2	March 10th 10 03:19 PM
Drop Down List - Source from another workbook	LittleAnn	Excel Discussion (Misc queries)	5	November 22nd 07 04:30 PM
Auto populate from list/source	Ron Coderre	Excel Worksheet Functions	0	August 17th 07 01:48 AM
Updating Source List	irish2171	Excel Discussion (Misc queries)	5	July 20th 07 09:32 PM
Combobox list source	Chris Thompson	Excel Programming	3	August 26th 03 02:18 AM