Results 1 to 2 of 2

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

Threaded View

  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

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