filtering rows w/ VBA

[Nondisclosure007]

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?

 

[Steve]

Hi NonD,

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

 

[Steve]

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

 

[Nondisclosure007]

Hi NonD,

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









- Show quoted text -