conditionally hide or filter columns?

[mart10]

I am using Excel 2007 I have a datasheet mixed up of entity, counterparty and bank account data in mixed order which cant be changed. In the top row I have just put E, C or A flag on each column of appropriate data

Question is can I filter or conditionally hide columns (- like you can for rows of data) directly in the sheet I dont want to use pivot table solution

 

[SkipVought]

hi,

Question is can I filter or conditionally hide columns (- like you can for rows of data) directly in the sheet

Excel has no built-in feature to filter rows in any way as you would filter columns, since tables are not structured to do that and it is not a best and accepted practice to stucture analytical tables in that way. I sense that you have some sort of summary base report that you want to report in various ways, that would best be accomplished from a normalized table and reported using one or more PivotTables or Queries.

But you can turn on your macro recorder and record doing what you want to do, and then modify the code to perform interactively according to changes in your data. You can get help customizing macros in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mart10]

thanks will try macros. Yes I know should go down normalised approach , but this is just a huge block of data I need to populate and clense as it is , before using these filters. The output is then going to populate a relational datatabse