Deeting rows based on entry in a cell
Hi,
I have a user defined function that places a key word in the last column of
data, making the data easier to sort. There are hundreds of records but in
column F the function places the key word from 3 choices - Processed,
Pending, Finished. How can I set up a macro to delete all the records apart
from "Processed".
OR having allocated the keyword using the function move all the Pending
records to a separate sheet and the Finished records to a third sheet and
then tidy up any gaps.
Thanks
Gaz
|