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.

[StephenR]

Perhaps this will start you off

Please Login or Register  to view this content.

[MD011]

Thanks very much I will give it a go

[MD011]

I need this to search for multiple headers, what do I need to change in the code to make this happen?

So for example search for "Testing" and "Testing2"

Thanks in advance.

[StephenR]

Please Login or Register  to view this content.