I am trying to write a macro which will delete an entire row of data if by looking at column I, the cell is greater or equal to the value in the next cell one row down. For example if Cell I2 has a value of 3 and Cell I3 has a value of 1, then row 2 should be deleted. The macro needs to continue down the column i until the next row becomes a lesser value than previous, so when cell I7 is 14 and I8 is 18, then the macro should stop. I am lost on how to do this. Thanks,
Bookmarks