New to VBA but need a simple formula to insert rows based on multiple cell values.
To add context, I'm creating a "rent roll" for commercial property. There are "x" amount of tenants and each tenant has "y" amount of rental increases through out their term.
x >= 1
y >= 0
Row 1 is my Header Row
Row 2, Column 1 is the start of the "x" variable with x amount of Rows
Row 2, Column 2 will have an input cell for each "x" which equals y
The code needs to insert y amount of rows below each x.
Thank you in advance.