i dont know how big your data base is but the combo box from the forms
toolbar will let you select a source list from another work book,but the
other book neds to be open for you to see any thing.The only way i can see is
you copy and paste your list as a quot;paste linkquot; and work your drop downs of
that quot;linked listquot;
--
paul
remove nospam for email addy!
quot;Attyquot; wrote:
gt; I want to be able to use a seperate work book to hold a list of data that I
gt; require to populate other seperate workbooks.
gt;
gt; Example - quot;Book Aquot; would hold the master list of data to be used in the drop
gt; down
gt; list
gt; quot;Book Bquot; would use the list from quot;Book Aquot; to populate the cells
gt; I`ve tried the sugestions in the help menue but failed
- Apr 13 Sun 2008 20:43
validation lists from seperate work books
close
全站熱搜
留言列表
發表留言
留言列表

