Filtering specific columns

[vikkxx]

I am trying to filter columns a-e inclusive but column F,G,H,I,J have a summary of all the data that is in columns a-e on rows 1-15.

This summary cannot be moved as it pulls specific information using formulas. I need to be able to filter columns a-e (row 1 is the header row) but not impact my summary on columns F-J. Currently it is hidden when the filter is on.

Help

 

[Magriza]

Hi and welcome to the board.

Filtering hides the non-relevant rows and it is therefore not possible to only filter certain columns - it's an all or nothing event.

You could see if you could transfer the information needed for the summary into a textbox (set to not move/size with cells).