delet rows based on cel content
Hi,
How can I create a macro that would delete two rows. The first row is the
one where the cell value in Column A is "L" and the second row is the row
above it.
So if A15, A20, A23 has the value (and only value) of "L" then delete it and
the row above it, which would be A14, A19, A22.
Thanks,
|