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 <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

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