I have attached a file of some sample data to assist in my question.

Basically I would like a VBA macro that will keep the lines that are highlighted yellow based upon the fact that G6 matches the value of 672 and then it has a negative amount in I6 that is equal to H5*-1. If all of this criteria is true then keep the two matching rows. If not then delete all other rows that do not match this criteria.

Is this possible? Thank you for your help!! I will leave good feedbackSample Date for VBA.xlsx