Hi,
I'm trying to make a filter for certain columns in excel 2003.
Because of the amount of date the filter cant hide the whole colums but only certain cells (lets say C10:J20).
How it works:
For every project i have to fill in, the sheet gives a prediction for certain numbers for all the owners.
The amount of owners is different every project, so i made a sheet for 100 owners and if there are only 8 owners it filters the other 92.
I made a formula that the 8 owners will be numbered 1-8, and the other 92 gets the value 'xx'.
In a vertical list i can easily filter them by 'does not equal' 'xx'.
But i have certain colums that have to be filtered horizontally (unfortunately it is not an option to ctrl c + paste special with tranpose to change it into a vertical list). Does anyone know if it is possible (and how) to create such a VBA code that filters certain cells and not all the columns in the whole sheet?
I've been looking for this for over a week but can't find it anywhere!
Regards,
Steven
I'm trying to make a filter for certain columns in excel 2003.
Because of the amount of date the filter cant hide the whole colums but only certain cells (lets say C10:J20).
How it works:
For every project i have to fill in, the sheet gives a prediction for certain numbers for all the owners.
The amount of owners is different every project, so i made a sheet for 100 owners and if there are only 8 owners it filters the other 92.
I made a formula that the 8 owners will be numbered 1-8, and the other 92 gets the value 'xx'.
In a vertical list i can easily filter them by 'does not equal' 'xx'.
But i have certain colums that have to be filtered horizontally (unfortunately it is not an option to ctrl c + paste special with tranpose to change it into a vertical list). Does anyone know if it is possible (and how) to create such a VBA code that filters certain cells and not all the columns in the whole sheet?
I've been looking for this for over a week but can't find it anywhere!
Regards,
Steven