macro to delete rows based on returned row reference

Hey all,

I need help coding a macro.
Please see the attached sample data.

The formula in “K” references the number of the row from column “H” where SDAMT and SDCASH match.

I need a macro to delete:

• The row number that the formula in “K” is referencing
• As well as the row that the value in “K” is in.

Example, K3 says 2 because H2 and I3 match each other. Based on this I need row 2 and 3 deleted

Can anyone help?

Thanks

In your real worksheet does column L have anything in it? The reason why I ask is because deleting row references in a loop will be problematic with the information you provided. There are many ways around this, ie using column L temporarily, but I would like a little bit more information that way I don't supply you with a code that could be flawed later on.

column L would be temporary. I would likely have the macro generate the formulas in that column, delete all necessary rows based on the values, and then delete column L once finished

Not quite sure if you answered my question so here it goes:

Please Login or Register  to view this content.

it worked great, thanks so much.
and my apologies, no, there is nothing in column L in my real workbook.