Dependent List- Data Validation

A

Annie

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
 
A

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
 
Top