Hi I have a macro that creates a pivot table but what I need if for each
column of data that does not include the word "Student" to be removed:

So starting at column b the first column header in the pivot table would be
in cell B3 and if this cell does not have the word Student within the text
string then that column needs to be removed!

Hope you understand? Regards Neil