+ Reply to Thread
Results 1 to 5 of 5

Excel VBA Macro - Deleting Specific Data based on criteria

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    9

    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.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Excel VBA Macro - Deleting Specific Data based on criteria

    Perhaps this will start you off
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-08-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    9

    Re: Excel VBA Macro - Deleting Specific Data based on criteria

    Thanks very much I will give it a go

  4. #4
    Registered User
    Join Date
    12-08-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    9

    Re: Excel VBA Macro - Deleting Specific Data based on criteria

    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.
    Last edited by MD011; 12-08-2014 at 12:30 PM.

  5. #5
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Excel VBA Macro - Deleting Specific Data based on criteria

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-01-2014, 01:17 PM
  2. HELP! Macro to Copy specific cells from one sheet to another based on specific criteria
    By atriscritti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2012, 11:05 AM
  3. [SOLVED] VBA code for deleting Rows that contain specific criteria from Filtered Data
    By carlosriver24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 12:23 PM
  4. Macro to insert data in specific cell based on criteria
    By SAsplin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2011, 08:08 AM
  5. Deleting Rows Based on Specific Data
    By Jakz34 in forum Excel General
    Replies: 1
    Last Post: 04-12-2011, 09:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1