Data Validation Question

[sdrubezki]

Hi everyone,

I'm trying to build dependent lists in Sheet1, with the source in Sheet2 as follows:
Brand Product
1 pen
1 pencil
1 computer paper
2 laptop
2 telephone
etc

The idea is that user chooses brand and only products of that brand are shown. But I want to show the brand only once.

I tried pivot tables and offset without success (perhaps I don't use correctly). Can anyone assist?

Thanks in advanced.
Sebastian

 

[hiker95]

sdrubezki,

You can upload your workbook to www.box.net and provide us with a link to your workbook.

 

[sdrubezki]

Hi hiker, check this example
http://www.box.net/shared/r5c7r6aucs
Thanks!

 

[hiker95]

sdrubezki,

You need to follow the examples in the below link to setup your worksheets to either fit your needs, or change your worksheets to fit the examples.

There are also some workbook examples to download.

Dependent validation lists. Debra has a neat little tutorial here.
http://www.contextures.com/xlDataVal02.html