My company has a program that generates reports as an excel spreadsheet. It has many columns that we do not need. Is there a way to format a new sheet the same way each time? The reports open as a new sheet each time so a macro would not work would it? Thanks