Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unique filter on different sheets ?

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

1 Solution

Accepted Solutions
sunny_talwar

Field

NameOfield

Search String

COSTO

View solution in original post

4 Replies
sunny_talwar

Use OnActivateSheet trigger to get this done....

Not applicable
Author

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

Field

NameOfield

Search String

COSTO

effinty2112
Master
Master

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