Horizontal/Column Filtering

[sumonrezadu]

Dear

I frequently need filtering data horizontally. In attached file, I need to filter segment at first (B1) and then respective model of that segment should be visible so that I can easily find out my desired model from the short list (B2). Can anyone help?

Thanks in advance.

PS: Macros and module here I got from this super Forum from the post of ELFIJKA on 15-Mar-2019 with title "Vertical + Horizontal Filter (Looking for easy way)". I'm grateful to him.

[SanjiVinsmoke]

Hi Sumonrezadu,

As much as I would love to learn horizontal filtering as well, I would need to inform you that as per my research over the years, Excel does not provide any utility to filter horizontally but as always there are workarounds that can be used. You can always transpose the table by selecting all the data and then navigating to “copy special “ select “ values” and tick on transpose. Now you have the same data transposed by 90 degrees, you can use the inbuilt filter options now.

I hope this helps! Thanks

[sumonrezadu]

Thanks for your response. Actually I was looking for alternative of data transpose.