I am really new to VBA/Macro, and this is my first question here, so please bear with me.

I am trying to write a macro for the following situation, but so far I have not had any luck.

I am using Excel 2019.

Below is a simplified view of my excel sheet that in reality has more than 100k rows like this:

A | B | C | D |

2551 | 2551 | true | |

2552 | 2552 | true | |

2554 | 2555 | false | |

2555 | 2557 | false |

Column A is one table, columns C and D - another.

Column D contains an IF formula to compare if columns A and C are equal and show true or false.

I am keeping two sets of data in different table to auto-update the formula results after any rows changes.

What I need is a macro to:

1. check column D from up to down (since whatever VBA I have found in forums check from down up),

2. find the false result (while the value is in a formula),

3. insert a row above the row with the false value,

4. after this happens, the table will have the following view:

A | B | C | D |

2551 | 2551 | true | |

2552 | 2552 | true | |

2554 | false | ||

2555 | 2555 | true | |

2557 | false | ||

5. the row with 2555 values will become "true", and I want the macro to go down (not start looking from 1st row anew), find the next "false", insert row and same way down to the last row of the sheet.

Is such a Macro/VBA possible?

Thanks a bunch in advance, this will save me tons of time.