Hello All,

I need help writing a macro that will add blank rows based on cell values. I've attached a sample table to show what I mean. I have a list of names and box numbers. While the box numbers are in numerical order, they skip some numbers by design. What I want to do is have a macro that will see when a number is skipped and add a row (or more in some cases) for it. The new rows do not need to have the missing numbers placed in them, just having the blank space is enough.

Thanks


Book1.xlsx