I have a table that list types of employee training in the columns and employee names and supervisor names on the rows. I have macros set up to sort by supervisor name, but I want the spreadsheet to hide all the colums that do not have anything in them (either color or a letter) once that macro is clicked and the spreadsheet sorts. Basically once a supervisor sorts to show their employees I want to hide any columns that don't apply(because there are hundreds of types of training). I hope that this makes sense. I have tried several options but none have worked. That may be my fault because I am not very good with excel formulae. Thanks for your time!