2 seperate current selection box!

[#1]

I have 2 sheets withe 2 different table. I want use 2 current selection box (csb) with next condition:

Selection fields  in csb1 in sheet 1 must be hidden in  csb2 in sheet 2 and if I switch to sheet 1 my selections must be visible in csb1

Selections fields in csb2 in sheet 2 must be hidden in csb1 in sheet 1 and if I switch to sheet 2 my selections must be visible in csb2

[Anonymous]

Hi Majid,

Try alternate states.

Regards,

Krishna

[#3]

Thanks a lot Krishna. It works perfectly!

[awhitfield]

Hi Majid,

if you are happy with an answer, then please mark it as CORRECT.

It helps other community users!

Andy

[#5]

Hi Andrew,

Thanks for your comment. I have done!

[awhitfield]

Nice One!