Let me setup the workbook. Since Google groups won't let me attach a
sheet, I'll do my best.
Sheet 1.
__________________________________________________ _____________
|_____|___A____|____B___|___C___|___D___|___E_____ ________________|
|__1__|Fruit/Veg|___X_____|
|__2__|Orange_|_________|
|__3__|Apple__|____X_____|
|__4__|Banana_|___X______|
|__5__|Grape__|_________|
|__6__|Tomato_|____X____|
|__7__|Carrot__|_________|

Sheet 2.
__________________________________________________ _____________
|_____|___A____|____B_____________|
|__1__|Name___|Produce____________|
|__2__|Smith___|Apple______________|
|__3__|Jones___|Tomato_Grape_______|
|__4__|Kline___|Orange_Carrot_Banana|
|__5__|Doe____|___________________|
|__6__|Hemmer|Carrot_Apple_________|
|__7__|Schultz_|Grape______________|

Note: Both sheets have headings in row 1 and sheet 2 has autofilter
currently on (which i want to turn off).
Now, what I want to do is sort to show only those rows that meet a
criteria (eg. has Tomato, Apple, Banana).

But I want that criteria built by what has an 'X' to it in sheet 1.

Is this possible?

Hi NonD,

Are you trying to use one worksheet's filtering to filter the second
worksheet?

"Nondisclosure007" wrote:

Let me setup the workbook. Since Google groups won't let me attach a
sheet, I'll do my best.
Sheet 1.
__________________________________________________ _____________
|_____|___A____|____B___|___C___|___D___|___E_____ ________________|
|__1__|Fruit/Veg|___X_____|
|__2__|Orange_|_________|
|__3__|Apple__|____X_____|
|__4__|Banana_|___X______|
|__5__|Grape__|_________|
|__6__|Tomato_|____X____|
|__7__|Carrot__|_________|

Sheet 2.
__________________________________________________ _____________
|_____|___A____|____B_____________|
|__1__|Name___|Produce____________|
|__2__|Smith___|Apple______________|
|__3__|Jones___|Tomato_Grape_______|
|__4__|Kline___|Orange_Carrot_Banana|
|__5__|Doe____|___________________|
|__6__|Hemmer|Carrot_Apple_________|
|__7__|Schultz_|Grape______________|

Note: Both sheets have headings in row 1 and sheet 2 has autofilter
currently on (which i want to turn off).
Now, what I want to do is sort to show only those rows that meet a
criteria (eg. has Tomato, Apple, Banana).

But I want that criteria built by what has an 'X' to it in sheet 1.

Is this possible?
.

Hi NonD,
Are you trying to use one worksheet's filtering to filter the second
worksheet?


"Nondisclosure007" wrote:

Let me setup the workbook. Since Google groups won't let me attach a
sheet, I'll do my best.
Sheet 1.
__________________________________________________ _____________
|_____|___A____|____B___|___C___|___D___|___E_____ ________________|
|__1__|Fruit/Veg|___X_____|
|__2__|Orange_|_________|
|__3__|Apple__|____X_____|
|__4__|Banana_|___X______|
|__5__|Grape__|_________|
|__6__|Tomato_|____X____|
|__7__|Carrot__|_________|

Sheet 2.
__________________________________________________ _____________
|_____|___A____|____B_____________|
|__1__|Name___|Produce____________|
|__2__|Smith___|Apple______________|
|__3__|Jones___|Tomato_Grape_______|
|__4__|Kline___|Orange_Carrot_Banana|
|__5__|Doe____|___________________|
|__6__|Hemmer|Carrot_Apple_________|
|__7__|Schultz_|Grape______________|

Note: Both sheets have headings in row 1 and sheet 2 has autofilter
currently on (which i want to turn off).
Now, what I want to do is sort to show only those rows that meet a
criteria (eg. has Tomato, Apple, Banana).

But I want that criteria built by what has an 'X' to it in sheet 1.

Is this possible?
.

On Jan 12, 4:21*pm, Steve wrote:
I'm using sheet one to determine what should be filtered in sheet 2.

Hi NonD,

Are you trying to use one worksheet's filtering to filter the second
worksheet?



"Nondisclosure007" wrote:
Let me setup the workbook. *Since Google groups won't let me attach a
sheet, I'll do my best.
Sheet 1.
__________________________________________________ _____________
|_____|___A____|____B___|___C___|___D___|___E_____ ________________|
|__1__|Fruit/Veg|___X_____|
|__2__|Orange_|_________|
|__3__|Apple__|____X_____|
|__4__|Banana_|___X______|
|__5__|Grape__|_________|
|__6__|Tomato_|____X____|
|__7__|Carrot__|_________|

Sheet 2.
__________________________________________________ _____________
|_____|___A____|____B_____________|
|__1__|Name___|Produce____________|
|__2__|Smith___|Apple______________|
|__3__|Jones___|Tomato_Grape_______|
|__4__|Kline___|Orange_Carrot_Banana|
|__5__|Doe____|___________________|
|__6__|Hemmer|Carrot_Apple_________|
|__7__|Schultz_|Grape______________|

Note: Both sheets have headings in row 1 and sheet 2 has autofilter
currently on (which i want to turn off).
Now, what I want to do is sort to show only those rows that meet a
criteria (eg. has Tomato, Apple, Banana).

But I want that criteria built by what has an 'X' to it in sheet 1.

Is this possible?
.- Hide quoted text -

- Show quoted text -