View Single Post
 
Old 12-08-2014, 08:43 AM
MD011 MD011 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2014
Posts: 2
MD011 is on a distinguished road
Default Excel VBA Macro - Deleting Specific Data based on criteria

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.
Reply With Quote