How to set built-in filter for multiple selections? (perhaps through VBA?)

[Rnkhch]

Hello,

I have multiple tables in my sheets, and I want each of them to have the built-in filter independently, but I can't do that. For example, I select C31:AH71 and I turn the filter on at 'Home>Sort & Filter>Filter' which works well, but I can't simultaneously apply the filter to for instance AL31:BQ71 and the remaining tables in the sheet. And if I make multiple selections by holding down the control key and try to turn on the filter, then it gives the error that this cannot be done on multiple ranges. Is there any way to do this?

Thanks for any input!

 

[Peter_SSs]

Turn each of the tables into formal Excel tables (Insert ribbon tab -> Table)

But note that if you have tables that overlap vertically, which it looks like you do) then hiding a row via filters in one table would also hide that row in any other table that the row overlaps.

 

[Rnkhch]

Ah, this would have been great, but the problem is that I get this error: "Formulas or rich data types in the header row will be removed and converted to static text"

(This essentially goes back to one of my earlier posts:

Graph dynamic range and lines don't work properly when one or more values are not present; legend

Hello, This question is related to my previous post here: (How to change axis spacing for dynamic axis range?) I got the dynamic ranges, axis, and error bar (standard deviation) to work properly, but now I'm facing new issues where if one or more values in the series is not entered, then the...

www.mrexcel.com

All the data in the table including headers are derived from formulas. In particular, a big portion of the header row displays the time point days automatically for the charts to dynamically adapt to the table, as more days are generated by the students who enter data in the source lists.)

 

[Peter_SSs]

All the data in the table including headers are derived from formulas.

In that case, if I have understood what you want, I don't think that you can do what you want to do.

 

[Rnkhch]

I see. Thanks for checking anyways.