** Help ** VBA QUESTION - CUT AND PASTE ROWS IF CELLS IN CERTAIN COLUMN ARE SPECIFIC VALUE

[brad7989]

So I have data that comes in that is in variable length of rows for each data set.

There are some rows that come in that are not needed though.

What I need to do is have VBA search through the data and if a row has a cell (always in the same column for each instance) that is a certain value, it needs to CUT the entire row and paste it several rows below the end of the (variable length) data.

ALSO: there may be different things before or after the specific keyword in the column that determines if the row needs pulled.

Thanks!

 

[Tom Urtis]

You can help yourself by helping people who are reading this to understand:
• which column it would be
• what the keyword(s) are

If the keywords could be any word or phrase under the sun, then an inputbox would maybe be the way to go, but that is not clear based on your missing details.