Hi,

I want to define define two dynamic range to help me creating dropdown
lists.

I have person's data in column A and B, FirstName in 'A' and the
LastName in 'B'. Now on a different sheet i want to provide two
selection lists, one for the first name another for the second name.

First List should be populated with the distinct first names and
second list should be populated with the Corresponding Last Names
after selecting the First Names.

I am avoiding Macro to achieve this, is there a way out ? please
help.

Thanks,
Avinash

Try this link:

http://www.contextures.com/xlDataVal13.html

--
Dan