Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Annie
 
Posts: n/a
Default Dependent List- Data Validation

Cell A1 contains list created by choosing Data, Validation list and
specifying a named range for countries. Works fine.
Cell B1 must return a list or Order Numbers from the country choice in cell
A1. The Order Numbers are in a named range, that begins at cell D7 in another
worksheet. I've been trying to work with a few examples posted here, but
cannot figure it out.
Can anyone help? Annie

  #2   Report Post  
Annie
 
Posts: n/a
Default

Cell B1 must return a list or Order Numbers from the country choice in cell
Should be Cell B1 must return a list <bOF</b Order Numbers from the
country choice in cell


"Annie" wrote:

Cell A1 contains list created by choosing Data, Validation list and
specifying a named range for countries. Works fine.
Cell B1 must return a list or Order Numbers from the country choice in cell
A1. The Order Numbers are in a named range, that begins at cell D7 in another
worksheet. I've been trying to work with a few examples posted here, but
cannot figure it out.
Can anyone help? Annie

  #3   Report Post  
Annie
 
Posts: n/a
Default

Studied the contextures site examples and came up with the solution.
http://www.contextures.com/
Annie

"Annie" wrote:

Cell B1 must return a list or Order Numbers from the country choice in cell
Should be Cell B1 must return a list <bOF</b Order Numbers from the
country choice in cell


"Annie" wrote:

Cell A1 contains list created by choosing Data, Validation list and
specifying a named range for countries. Works fine.
Cell B1 must return a list or Order Numbers from the country choice in cell
A1. The Order Numbers are in a named range, that begins at cell D7 in another
worksheet. I've been trying to work with a few examples posted here, but
cannot figure it out.
Can anyone help? Annie

Reply
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 lists [email protected] Excel Discussion (Misc queries) 5 June 25th 05 07:44 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Data Validation list boxes Watson Excel Discussion (Misc queries) 4 May 26th 05 05:12 PM
DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) Wayne Excel Discussion (Misc queries) 0 March 22nd 05 07:24 AM
data validation list from two columns otinky Excel Discussion (Misc queries) 1 March 21st 05 02:13 PM


All times are GMT +1. The time now is 09:51 PM.

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

About Us

"It's about Microsoft Excel"