Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have 3 sheets with several objects(tables-displays data,listbox-displays name,calendar object-for filtering 'from','to' using variables in each sheet
Now i have used 3 alternate states to keep data seperated from each sheet after filtering.
i.e If I give range from jan to mar in sheet1, i want data to be filtered only in sheet1,other sheets should not be changed.
But,even after having states,if I change in 1 sheet, the changes are affecting the other sheets also.
How can we implement it?
can u use "Clear All" in sheet level action
Tried with clear all,but its not working
Clear all could be a way,but i want my filtered data to be there even when i switch between sheets