Compare 2 sheets and delete duplicate rows

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?

I inserted the following code after the line Sheets(2).Select

Please Login or Register  to view this content.

you have to substract 1 to you LSearchRow because you just deleted one.
Pierre

Simple as that.....Thanks.

Dont suppose you know a code to copy sheet 1 into word?

here is a place where you will find your information:

http://www.exceltip.com/st/Copy_work...Excel/481.html
regards
Pierre

Originally Posted by p24leclerc

I inserted the following code after the line Sheets(2).Select

Please Login or Register  to view this content.

you have to substract 1 to you LSearchRow because you just deleted one.
Pierre

I have an issue with the code, it wont search the next blank cell and paste the copied tems, it is paste over the same cell.

I think you want to copy the new records at the end of the existing ones in the sheet Invoiced. To do this, you have to set the row number where to copy the data by the formula below:

Please Login or Register  to view this content.

Thanks for your help.