Remove Lines Based on Key Lookup

[gkenens]

Short backstory of the objective:
I have an expense report, and if the employee itemized the expense (split it out), the itemizations AND the total expense line item show up on the report (so the amount is duplicated). The report has two different key columns: Entry Key (primary key for every expense line item), and then Parent Key (blank, unless it's an itemization, and this is the Entry Key of its parent). I essentially need to scan the second column for any parent keys, and if it finds one (aka column 2 is not blank for that row), then lookup that parent key in the Entry Key column (col 1). When it finds the parent, delete that line from the spreadsheet.

Here is what I currently have, which has been adapted from another search/remove loop I had written (that works fine). I'm struggling with the match function, where it looks up the parent key in the entry key column.

I'm fairly new to the VBA side of Excel, so I could be missing something obvious. Thanks in advance for any help!

Please Login or Register  to view this content.

[gkenens]

I solved it by replacing the above with the following. The biggest hold-up was because there could be several lines with the same parent key, the fn would halt when it looked up a value in the first column that it had already deleted.

Please Login or Register  to view this content.