+ Reply to Thread
Results 1 to 2 of 2

Clear contents of cells that do not contain specific text, sort cells that do

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Clear contents of cells that do not contain specific text, sort cells that do

    Hi,

    I'm looking for a macro that can go through all the contents of Column A (which could continue for thousands of rows) searching for any cell that will contain the word "dos*". Now the cell may not be simply "dos" it could be "double dos" or "other dos" and I want to make sure to keep all the ones that have that sequence of letters in it wherever it may be. All cells that do not contain this text should have their contents cleared and once that's completed all cells that do contain "dos" should be formatted to the top of the sheet, under the title that's already there. I have attached a spreadsheet with one sheet to show what the data will look like before and another sheet to show what it should look like after.

    Thanks for this, you guys have already tought me so much just by going through various threads on here. I really appreciate the help!
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Clear contents of cells that do not contain specific text, sort cells that do

    Perhaps something along the lines of:

    Please Login or Register  to view this content.
    Colin Legg provides a much better overview (and indeed) code of how to go about deleting rows in Excel - see: http://www.xtremevbtalk.com/showthread.php?t=300757

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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