I am trying to "reinvent the wheel" on an existing app with buggy
macros.

My main challenge (as I am fairly new to Excel VBA) is to find a way to
evaluate a specific cell within a row and, if it is a match, move that
whole row to a different worksheet within the same workbook. I have to
ensure that if there are multiple instances with this condition that
they are moved to the correct worksheet, no rows are overwritten on the
destination sheet, and that blank rows on the original sheet are
deleted.

There will be a number of keywords in different cells that will be
evaluated and could end up on one of several destination sheets.

For example:

In column 13 for any given row, I am looking for the string "DELETED"
which may or may not have other words in the cell. If it is found, the
entire row should be copied to the "DELETED" worksheet. There are a
variable number of rows each day, but the columns stay constant. Once
all the deleted events are removed, the remaining rows would be
evaluated for occurrences of other strings. Once completed, the ones
that don't match any of the search criteria will remain on the original
sheet for further processing.

The next thing I need to do is divide the remaining rows up as either
value 1 or 2 (left or right). There may be multiple rows with the same
channel value that would all need to be grouped as either 1 or 2;
others may have only one channel assigned.

I appreciate any insight you may have regarding these issues; I hope
this information is specific enough. If not, let me know and I'll be
glad to provide it.


Thanks!

Judy