I am only familiar with simple macros to filter databases, hide known columns etc. However I need to be able to write a macro that reviews the data in all of the specified columns of the sheet and hides any columns which contain cells containing a particular character ("X"). The basis of the spreadsheet is to have one column into which you can enter a series of values and these are compared against a set of 'standard columns' (to the right of the entry column). Where there is a match, the standard column will show a 'tick' and where there is not a match it will show 'X'. I want to be able to apply the macro to filter out (hide) any standard columns that show an 'X' leaving only the standard columns that show an acceptable match to the entry column. How do I go about writing a macro to do this (and also a cancelling macro to revert back to the full sheet view) - bearing in mind I'm not familiar with VB code ?