Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have scenario like :
There are two sheet say Sheet1 and Sheet2.
And there is one field named as %Dimension which contains number of other fields.
%Dimension is at Sheet1 also at Sheet2
What happens is whenever I select filter on %Dimension fields on Sheet1 those are selected in Sheet2 as well.
I want the selection should be Sheet specific. Selection on sheet! does not affect on sheet2.
Well, What I have tried is by setting trigger to Sheet2 that whenever sheet get activated it should clear all the fields.
But i whn i get back from sheet2 again my selction on sheet2 get lost. so i want to avoid this situation.
Kindly help.
Regards,
Mahamed
How about putting your 2 sheets in different Alternate States.