Cull rows based on searching for text in a column.

Pat,

Welcome to the forum!
Give this macro a try:

Please Login or Register  to view this content.

How to use a macro:

1. Make a copy of the workbook the macro will be run on
   • Always run new code on a workbook copy, just in case the code doesn't run smoothly
   • This is especially true of any code that deletes anything
2. In the copied workbook, press ALT+F11 to open the Visual Basic Editor
3. Insert | Module
4. Copy the provided code and paste into the module
5. Close the Visual Basic Editor
6. In Excel, press ALT+F8 to bring up the list of available macros to run
7. Double-click the desired macro (I named this one tgr)

Sorry tigeravatar I did not see your post - this may be another option. Sorry about that tigeravatar as I don't like over posting other contributors.

the rest of the row information in that row is copied to a brand new spreadsheet.

So you do not copy the entire row just everything from column C to end of the row - are the rows fixed width or do they vary. It is not hard to iterate through the entire workbook and check every sheet for a keyword and then copy the data across to a new worksheet. If you could just upload a sample workbook just showing how the data is set out, where the value/word will occur (which column) and what data is copied across to new worksheet - like a before and after - only need a few entries just so can see how the data is set out. Depending on your VBA skills you could modify something like the following (this searches Column B). I have not tested this code - I have just modified it from previous project. As I say a sample worksheet would help

Please Login or Register  to view this content.

Depending on your VBA skill level you could modify this. Add this to a module and change the values I have marked

pthielan,

I deleted the original contents because you used the word "Cull" which meant to me that you wanted to move the items to a new sheet and delete them from their original locations. If that is not the case, you just need to delete this line in the macro so that the items do not get deleted from their original locations:

Please Login or Register  to view this content.

[EDIT]
@smuzoen, no worries about posting here. The more solutions, the better I say

Sorry - my code was not tested - glad tigeravatar's code worked. For what it is worth (now tested)

Please Login or Register  to view this content.