Script to delete rows when condition fulfilled

Hi,

I have a sheet, in which I have to delete rows when the content of column X (f.e. "EUR" equals the content of column Y (f.e. "EUR"). The number of rows is not a fixed number, could be different each time I receive the sheet in my mailbox.

I first add a column Z (=if(X=Y,"YES","OK"), and wanted to continue with IF Z="YES", then select the row, and delete it, but I do not know how to continue. If possible a solution whereby all meant rows are deleted at once, or if not possible, checking row by row.

Rutger

You could autofilter column Z, select a value of "YES", and then delete all the visible rows.

Hi Rutger,

The code below should do it (if I've understood).

Please Login or Register  to view this content.

Cheers,
Dom

Thanks guys.

Roger