I have a Table (Table1) in one of my sheets. Let's say it goes from A2:D45.
From A50:D60, I have some additional cells (range) being used for other items.
When I go to A46 and input something, the table increases by one row, now including the data input in A46. This is what I want it to do.
However, the empty space between the last row of the table and A50, has now decreased.
Eventually my table will extend down past A50, which will cause issues with the data I have in A50:D60.
How can I go about making it so that no matter how many rows my table extends. ... I will always have 5 rows of space between my table's last row, and the next used range (i.e. A50:D60)?
Essentially I want to ensure that things get "pushed down" each time a my table extends by a new row.
I was thinking it would have to be in VBA ..... something like: whenever the table is extended, count the number of blank rows between the last row of the table and the first row (down) which is not blank, if less than 5, add X number of rows between to always have 5 rows between the last row of the table and the first not blank row.
Thoughts? Ideas?
-Spydey
From A50:D60, I have some additional cells (range) being used for other items.
When I go to A46 and input something, the table increases by one row, now including the data input in A46. This is what I want it to do.
However, the empty space between the last row of the table and A50, has now decreased.
Eventually my table will extend down past A50, which will cause issues with the data I have in A50:D60.
How can I go about making it so that no matter how many rows my table extends. ... I will always have 5 rows of space between my table's last row, and the next used range (i.e. A50:D60)?
Essentially I want to ensure that things get "pushed down" each time a my table extends by a new row.
I was thinking it would have to be in VBA ..... something like: whenever the table is extended, count the number of blank rows between the last row of the table and the first row (down) which is not blank, if less than 5, add X number of rows between to always have 5 rows between the last row of the table and the first not blank row.
Thoughts? Ideas?
-Spydey
Last edited: