natemoss1218
New Member
- Joined
- Aug 6, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hi all! I am in need of bigger brains than mine.
Basically, let's say I have a table of 5 rows. When I add data to the last, 5th row, I want the table to automatically add a blank, 6th row. Essentially, there should always be one blank row at the end of the table so when I then add data to the 6th row, you guessed it, the table adds a new, blank 7th row.
I've seen this done live in Excel, so I know it's possible. Just not sure if it is through VBA or something that can be adjusted in Excel's table settings.
Thank you in advance!
Basically, let's say I have a table of 5 rows. When I add data to the last, 5th row, I want the table to automatically add a blank, 6th row. Essentially, there should always be one blank row at the end of the table so when I then add data to the 6th row, you guessed it, the table adds a new, blank 7th row.
I've seen this done live in Excel, so I know it's possible. Just not sure if it is through VBA or something that can be adjusted in Excel's table settings.
Thank you in advance!