LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Data Validation - reference to another workbook

How can I create a drop down list refering data in aonther workbook?

I have created a NAME (says CUSTCODE) referencing a list of customer codes
in another workbook. And I would like to make a drop-down list refering this
list, using the Data Validation, but it would not allow me to select this
reference name.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation From Different Workbook Wally Excel Discussion (Misc queries) 2 November 28th 06 06:37 PM
Data Validation for list in a different workbook vicky Excel Discussion (Misc queries) 2 November 6th 06 10:25 PM
Data Validation From Closed WorkBook TeRex82 Excel Discussion (Misc queries) 2 May 12th 06 10:45 AM
Data Validation in another Workbook - HELP! Rich58 Excel Discussion (Misc queries) 2 January 29th 06 01:33 AM
Data Validation - using a list from another workbook PeterW Excel Discussion (Misc queries) 4 December 15th 05 07:18 AM


All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"