Unique filter on different sheets ?

[#1]

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

[sunny_talwar]

Use OnActivateSheet trigger to get this done....

[#3]

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 ...

[sunny_talwar · Accepted solution]

Field

NameOfield

Search String

COSTO

[effinty2112]

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