TreeView

I need to create something like a TreeView in Excel. I have one list,
the first column is the manufacturer of a product and the second column
contains the various models sold by that manufacturer example:

Manu1 -- Model1
Manu1 -- Model2
Manu2 -- Model1
Manu2 -- Model2
Manu3 -- Model1

I need the user to first select the manufacturer and based on that
selection to select only the model sold by that manufacturer. I do not
want a manufacturer to be displayed more than once nore do I what
spaces in a list. What would be the best approch to tackel this problem
in Excel?

Thanks in advance!

On approach is documented here:

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

Debra Dalgleish's site

--
Regards,
Tom Ogilvy

"Stephen" <snorrodusa@yahoo.com> wrote in message
news:1128962454.286934.123360@g49g2000cwa.googlegroups.com...
> I need to create something like a TreeView in Excel. I have one list,
> the first column is the manufacturer of a product and the second column
> contains the various models sold by that manufacturer example:
>
> Manu1 -- Model1
> Manu1 -- Model2
> Manu2 -- Model1
> Manu2 -- Model2
> Manu3 -- Model1
>
> I need the user to first select the manufacturer and based on that
> selection to select only the model sold by that manufacturer. I do not
> want a manufacturer to be displayed more than once nore do I what
> spaces in a list. What would be the best approch to tackel this problem
> in Excel?
>
> Thanks in advance!
>

Thanks Tom! Exactly what I was looking for. Worked Great!