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?
