J
jj66
I'm looking for the vba to delete/rows in a spreadsheet.
Specifically, I have a table within a spreadsheet. The table is 15 rows high
and 6 columns wide with the newest data in the top row and oldest in bottom
row. The user has to add to the table each day with new information. If the
new information on that day is, say, 5 rows then the oldest 5 rows are
deleted from the bottom, the existing info moved down and 5 new rows added
to the top ready for the user to complete.
Is there any vba I could use that would do this automatically? Could I make
it so that if the user clicks on a button, excel asks how many rows from the
bottom are to be deleted, the user inputs a number and then excel
automatically deletes these rows, moved the info down and adds the same
number of rows to the top ready for the user to complete.
Thank you
Specifically, I have a table within a spreadsheet. The table is 15 rows high
and 6 columns wide with the newest data in the top row and oldest in bottom
row. The user has to add to the table each day with new information. If the
new information on that day is, say, 5 rows then the oldest 5 rows are
deleted from the bottom, the existing info moved down and 5 new rows added
to the top ready for the user to complete.
Is there any vba I could use that would do this automatically? Could I make
it so that if the user clicks on a button, excel asks how many rows from the
bottom are to be deleted, the user inputs a number and then excel
automatically deletes these rows, moved the info down and adds the same
number of rows to the top ready for the user to complete.
Thank you