filtering rows w/ VBA
 

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?

filtering rows w/ VBA
 

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

filtering rows w/ VBA
 

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

filtering rows w/ VBA
 

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 -