hi,
what is the specific cell?
what is it matching?
what are the keywords?
how many different cells?
what are the cells?
how many cells are in the row?
how many destinations sheets? names?
what is the name of the source sheet?

-----Original Message-----
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

.