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

**RANDY LIPOSKY** · 01-06-2014, 01:13 PM

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".

Please Login or Register  to view this content.

Thanks for the assistance. Randy

**JOHN H. DAVIS** · 01-06-2014, 01:36 PM

Not sure about what you mean by freeze. But maybe?

Please Login or Register  to view this content.

**Leith Ross** · 01-06-2014, 01:51 PM

Hello Randy,

You will need to add your freeze date code to this macro. It is marked by a comment in the Do loop. I am assuming that "Top" is named cell on the worksheet "Summary". If it is not then the code will fail.

Please Login or Register  to view this content.

**RANDY LIPOSKY** · 01-06-2014, 05:21 PM

Thanks much for your responses. Neither macro was able to find the word "TODAY". Perhaps I misinterpreted what I was supposed to do but I copied them essential verbatim.

I attempted to attach an image of the spreadsheet so you could see exactly what I am talking about but it doesn't look like it worked.

The macro simply needs to go from 1 cell to another in column H looking for the word "TODAY". If you can get me that far, I can take it the rest of the way.

TODAY.JPG

**JOHN H. DAVIS** · 01-07-2014, 07:30 AM

Both codes should do that. If they are not working can you provide a sample with some data as depicted in the .jpg file?

Please Login or Register  to view this content.

**RANDY LIPOSKY** · 01-07-2014, 09:29 AM

Still did not work. Here is a sample of the forumulas used in those columns

TODAY1.JPG

**JOHN H. DAVIS** · 01-07-2014, 09:32 AM

I meant attaching a sample worksheet with some data which is not responding to the macros. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

**RANDY LIPOSKY** · 01-07-2014, 11:57 AM

Thanks much for all of your effort. I have managed to get the find function working with a Do Loop. It moves sucessfully from "Today" to "Today" but when it gets to the last "Today" the macro freezes and won't fully complete the macro. I don't have the ability to attach the spreadsheet.

Here's my current macro

Please Login or Register  to view this content.

**RANDY LIPOSKY** · 01-07-2014, 12:24 PM

PS: There is a Loop statement that I inadvertently left out

**RANDY LIPOSKY** · 01-08-2014, 09:46 AM

Sorry for the delay. I have attached a copy of the file that I am using with the macro

SUMMARY2.xlsm

Here is a copy of the macro I am attempting to use. Again, the intent of the macro is to freeze the dates in Column G.

Please Login or Register  to view this content.

**RANDY LIPOSKY** · 01-09-2014, 10:23 AM

For those that are interested, I finally got this macro to work. This is a handy little macro and may be beneficial to those that search for specific words in a column or row.

Please Login or Register  to view this content.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Create a Search Box on Userform: if search result found then do this, if not then do that

[SOLVED] Search for a value and if the value is found copy the whole row. And repeat the proces

[SOLVED] Search for string across header row, then search for another string down found column

[SOLVED] Macro ignores search code when 1 of the 2 search parameters is not found

Create a search box that jumps to items found in list

Bookmarks

Bookmarks

Posting Permissions