View Single Post
  #1   Report Post  
 
Posts: n/a
Default making only specified columns visible

I am trying to create a macro that will allow the user of a spreadsheet
to only view specified columns. It is easier to describe using an
example:

1/05 1/05 2/05 2/05 3/05

matt 2 4 6 5 3
chris 3 4 2 7 1
sara 1 1 9 8 5
ann 5 4 3 3 6

If the user only wants to see data for the month of Feb., is there a
way to have a macro hide all columns except those with a column heading
of 2/05? Thank you for your help in advance.