How can I retain the previous selection among different Buttons

[#1]

Hi QV,

In my sheet I have 4 buttons.

When I navigate from one button to another, the selections in previous button are not reflecting to current button selection.

So, my requirement is to have previous selections should not be cleared when i navigate among the buttons.

Thanks in Advance,

Ananth

[#2]

Thankgod Sasi, You did it. Now i got what I want.

Thank you soo much.

Ananth

[sasikanth]

Your Welcome

[#4]

Thanks for your detailed explanation on this Sergey.

Many thanks to both Sergey Makushinsky and sasikanth_Narne.

[SergeyMak]

You are Welcome!