Hi

I have a macro which transfers data from sheet 2 onto sheet 3 if certain criteria is met.

This works fine but i need to delete the rows from sheet 2 once the data has been transfered.

Is there a seperate code for this?Project_Review_Summary_TEST_V2.1(1).xls

Also is there a code to take sheet 1 tables and export onto word document?