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
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