Ask Your Question

Using multiple AutoFilters separately on same sheet? [closed]

asked 2020-09-06 21:28:54 +0100

yarow12 gravatar image

updated 2020-09-07 00:39:00 +0100

I'd like to have 5 sets of data on 1 sheet that are all filtered separately. The first image shows 2 of the sets. The second image shows a fail attempt at filtering them separately. Is there any way to make this work, or am I gonna have to use 5 separate sheets and multiple Windows?

image descriptionimage description

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by yarow12
close date 2020-09-07 02:01:26.937173

1 Answer

Sort by » oldest newest most voted

answered 2020-09-07 01:50:12 +0100

newbie-02 gravatar image

the ranges have to be 'row-independent', and you need to define ranges for them, [data - define range], to stay safe leave one empty row between ranges,

edit flag offensive delete link more


Well, that was simple. Thanks.

yarow12 gravatar imageyarow12 ( 2020-09-07 02:01:13 +0100 )edit

Question Tools

1 follower


Asked: 2020-09-06 21:28:54 +0100

Seen: 58 times

Last updated: Sep 07 '20