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

Cell B1 must return a list or Order Numbers from the country choice in cell
Should be Cell B1 must return a list <b>OF</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
>

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 <b>OF</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
> >