Hi all,

I have two worksheets. one is for ongoing activity. the other is to archive items that have been dealt with. I have a column entitled "outcomes" which has several possible entries that users select from s drop down menu.

Periodically - maybe once per day, or once per week i need to archive entries from the ongoing worksheet.

what i would like to do is have a macro that:

a) selects all rows from the "ongoing" worksheet that have Outcome = x, y or z

b) move those rows to the Archive worksheet (in the same workbook)


any help would be greatly appreciated