Filtering specific columns

vikkxx

New Member
Joined
Jan 28, 2010
Messages
1
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

Well-known Member
Joined
Nov 16, 2005
Messages
508
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).
 

Forum statistics

Threads
1,085,864
Messages
5,386,404
Members
401,997
Latest member
cizwiz

Some videos you may like

This Week's Hot Topics

Top