Transfers the selections using variable

[Anonymous]

Hi All,

Here is the scenario. I am having two sheets (Home & Trans) which is defined with two unique alternate states.

When user do the selections and clicks "Home" or "Trans" button the selections needs to be transferred to other sheets as well.

Attached the sample applications.

Note:

I dont want to use the "Triggers" on the "selections". Looking for the solution by using variable.

-Jay

[Anonymous]

Hi Settu,

   Your solution is close to my requirement. But thing is I dont want to show "(" "|" kind of symblos in current selection box. Also I need to consider the "Alternate State" as well. Let me know if you have any idea on this.

-Jay