To navigate to the target sheet (or table) would be ideal. But if that is
not possible, then to retrieve data from another sheet (or table) would be
okay.

Also, do you know if you can required "selection" from the second list once
a selection is made from the first list? And if so, how? Is Data Validation
List the best method of doing this, or is there another preferred method. I
was just trying to save desktop space and have the page look nice, thus the
reason for the drop down lists using Data Validation List.

I know this would be better achieved using Access but I don't have that
option.

"crispbd" wrote:


Do you mean that you would like the workbook to navigate to the target
sheet, or just retrieve data from that sheet?


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799