I am looking for a macro that clears fields in particular tabs in a workbook. I would like to clear from A2 to M2 all the way down (all data within this range). I want to set this to a command button so it clears these fields in the 'Import', 'Current', and 'Closed' tabs. There are formulas in columns N, O, and P within these tabs but that macro shouldn't clear these. Lastly, on the 'Table of Content' tab, where it is labeled "<Customer> Carelog", if it can replace whatever the customer may be back to say "<Customer> Carelog", that would complete this macro (necessary to restart report to new for user).