Delete rows on 2 different worksheets based on cell value from one worksheet

Hi,

Using VBA, I need to look at each row on worksheet2 and if the values of column O + Column P in a given row is zero, delete that entire row from worksheet 2, and at the same time delete the same row from worksheet1.

Please could someone suggest example code to achieve this.

Many thanks,

Hi,

Thanks for that, I can't seem to get it to work though, it is deleting every row. Not just rows with value of zero in those 2 columns.

Any suggestions?

Of course, I have attached an example of the layout, there are far more rows than this in the real thing.

I want to delete the entire row if the customer has no sales at all, so showing zero in both column O & P on the 2014 sheet. When a row is deleted from the 2014 sheet, the same row must also be deleted from the 2013 sheet.

Thanks,

Sorry I still can't get it to work. After everything else I have done with this I am surprised to be having so much trouble with a simple thing like this.

It deletes every row even though only a few of them show zero in both column O & P.

I am completely baffled by this.

At last I figured it out....

I was inserting this into a section of code where I had changed xlcaculation to manual, the figures had just been pasted onto the worksheet and so the values of the total columns were not manually calculating themselves.

I fixed it by adding this line in just above....

Please Login or Register  to view this content.

Anyway, many thanks for your help.