Afternoon Folks,

I have a database of information, and on a daily basis go through the jobs and update any that have been closed or cancelled by marking in row A "closed" or "cancelled".

Ive been searching for a macro that can do the following, but not had a lot of luck :

Search in a sheet named "database" for any that have either "Closed" or "Cancelled" against them, then copy all "Closed" jobs into a sheet named "closed", and any that have been cancelled in a sheet named "cancelled"

Then delete the lines within the "database" sheet and moved all other lines up, basically tidying it up.

A wee point in the right direction would be great.

Cheers,

Daywalker.