Results 1 to 11 of 11

Search within a column and repeat the search until all items are found

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Search within a column and repeat the search until all items are found

    I have a spreadsheet that has formulas in Column H that determine if certain data is present in column G, and if so, displays the word "TODAY" in the corresponding row in Column H. I want a macro to search Column H for the cells containing the word "TODAY". When it finds the word "TODAY", it freezes the date in the corresponding row in Column G and then searches for the next word "TODAY" in Column H, until all have been found and all dates have been frozen. Column H will have no more than 200 cells (H6:H206) with the potential for the word "TODAY" in a cell. I know how to freeze the dates but I don't know how to search Column H for the next available "TODAY".
    Sheets("SUMMARY").Select
    ActiveSheet.Unprotect  
       Application.Goto REFERENCE:="TOP"
       Cells.Find(What:="TODAY", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
            xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
            False, SearchFormat:=False).Activate
         ActiveCell.Offset(0, -1).Activate
    Thanks for the assistance. Randy
    Last edited by Leith Ross; 01-06-2014 at 01:30 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 09-13-2013, 11:02 AM
  2. [SOLVED] Search for a value and if the value is found copy the whole row. And repeat the proces
    By beamonemo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2012, 02:34 PM
  3. [SOLVED] Search for string across header row, then search for another string down found column
    By TucsonJack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:09 PM
  4. [SOLVED] Macro ignores search code when 1 of the 2 search parameters is not found
    By BrodyNoochie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2012, 05:21 PM
  5. Create a search box that jumps to items found in list
    By cadmancan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-27-2009, 11:44 AM

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