Hello,
I want to know how we can have different filter on different sheet without using set analysis
For exemple :
Sheet 1 : I want only Customer 1 data
Sheet 2 : I want only Customer 2 data
Sheet 3 : I want Customer 1 & 2 data
Sheet 4 : I want Customer 3 data
Thank you for your help,
Sarah
Use OnActivateSheet trigger to get this done....
Yes i have to go on sheet properties OnActivateSheet > Selection > Select in Field
Field "=NameOfield'
Search String "='COSTO'"
I have ever tried It doesnt work like this ...
Field
NameOfield
Search String
COSTO
Hi Sarah,
Another approach might be to create alternative states for your sheets. Place a listbox on each sheet, select your customers then lock your selection for that sheet's state.
cheers
Andrew