Hi,
I have two seperate tables and the top row is headers on each table, when I apply autofilter on one table its ok, when I try to add autofilter to second table the first table autofilters disappears.
Question:
Can I have two seprate tables with active autofilters at the same time?
Any help is apprecaited.
Corca.
The first AutoFilter don’t disappears if the second is in another sheet (same document).
Hi,
Yes you are correct about tables on seperate worksheets.
I meant to say that both tables are on the same worksheet.
Hi,
Thanks for reply.
I could not duplicate your file.
see sample below:
Table 1
header a
1
2
3
4
Table 2
header ABC
a
b
c
d
e
f
Can you get the above table to work on one sheet and two seperate autofilter tables?
Hi, @Villeroy, I had already tried to do it, but I couldn’t.
Can you explain the steps as you did.
Attention: rows cannot be shared between tables.
Please @Villeroy, why not explain the trick. I think it was explaned somewhere in Ask.
Please take a look to the hint about ‘To Apply an AutoFilter to a Cell Range’ there is a remark on how to do it.
Filtering cell ranges
I explained it on the first sheet.
See Data>Define…
Sorry, didn’t take attention.
Hi,
Yes, I defined each range seprately then applied autofilter on each and work.
Appreciate the help.
thanks.