Problem::

[#1]

Dear All,

Europe and Scandinavia/Russia and CIS on ADMIN button selection.. I want to show them active when I select ADMIN BUTTON... as shown in figure..

Plz reply soon...

I want to active Eastern .

[datanibbler]

Hi Rahul,

I don't quite get your problem:

=> So you don't want to actually select those values, but merely to show those as selectable (not the others) upon clicking that button - right?

<=> what about the others?

An idea would be to generate a third, identical table, linked by country_name, and select those two markets in that table (triggers on the button) -> that will allow only for selection of either of those values, no others.

HTH

Best regards,

DataNibbler

[#3]

For others valueI have to create many button as ADMIN and have to cover all market..

But I can't generate any link between the two sheet...

[tresesco · Accepted solution]

See the attached sample.

[#5]

Thanks tresesco