Excel VBA Macro - Deleting Specific Data based on criteria

[MD011]

Good afternoon everybody,



I am looking for some of your kind assistance to assist me in creating a macro for excel that will do the following:

I need the macro to search the workbook for specific headers in columns, for example "testing", and then delete all data in the cells below that header in that column, making sure to leave the header in place.

So for example if the column name was "Testing" then the macro would match "Testing" then delete all the data in that column BELOW the header.

I hope that makes sense. I am relatively useless to VBA etc as I am very new to it.

Any help would be greatly appreciated.

Thank you.