VBA to clear cells below header containing word

[higguns]

hello,

New to excel VBA and could use some help.

I am looking for a VBA to be able to use on a few different spreadsheets which will be automatically created from an android app that exports to a .csv file. After the csv file is created by the app, I need to be able to: A) clear all cells in a column under headers containing a specific word and B) save the file as a copy of the original file, with " - blank" added to the end of the file name.

All help appreciated!

Thanks

 

[higguns]

Sorry I wasn't clear.... I was originally just looking for the macro to run on one workbook at a time. Each workbook will have a single worksheet in it with headers (this is how the app exports the data to the .CSV file). I would run the macro (from a quick access button linking to the macro in the personal.xlsb so the macro can be run on any file) on each workbook/worksheet manually, unless it can be automated somehow to do it automatically to every file in the folder that doesn't have the suffix -blank? Is this possible? It would make it even less time consuming if it can be setup to do that?