Hello.

I have a program in excel that we are using to track our protective orders.
I have the information broken into two worksheets, one for active orders and
one for expired orders. The general user of this program will never see the
actual worksheets because of userforms that are made for them to work with.
My question is this:

I have a script written now that will search the active list for any records
that indicate that they are expired or have been terminated. It does this by
looking at column "X" to determine if the record itself is a test record, and
if it is not, it look at column "C" to get the value from the formula
("VALID", "INVALID", "EXPIRED", "TERMINATED"). Those values are determined
by a legnthly formula that references about 8 other columns in the record to
validate it. When the script finds one matching either "EXPIRED" or
"TERMINATED" it copies the entire row to the second worksheet and certain
information to a third worksheet to printout for manual updating of the hard
copies. The problem I am having is that I cannot get it to delete the record
after it has copied it to the other sheets. How can I get excel to delete
the records off of Sheet1 after it has been moved to Sheet2?

Any help would greatly be appreciated.