Using VBA to delete values based on a condition

[KatjaL]

Hi everyone,

I'm trying to enter a VBA code that will allow me to delete certain cell values in a column if they are smaller than the corresponding value in another column.

For example, the values in column C1 and D1 need to be smaller than the value in B1, otherwise their values should be deleted (this continues down all the rows of data).

Any idea if this is possible?

[JasperD]

Please Login or Register  to view this content.

[KatjaL]

Thanks JasperD! Just to check - If I have to extend the number of columns which I'm checking B against, I just increase the number of if lines?

[JasperD]

yes, that's correct