Move down row and delete last row
I have a VBA macro that moves the rows down after data entered and I press Enter key. I want to limit the range of movement.
In my example, after I entered the data rows are moved down, but I do not want that after moving all data is visible.
I want to value or data in the last row disappears and in its place came second last, and so on each following.
I also want to limit the VBA macro only the data range A1:G10. At any time, it is evident only 10 rows
Another problem is if I make a mistake when entering data. Is there a possibility to create VBA UNDO (or have some copy all data to another Sheet in the moment the entering entry, when I press Enter key)
Can someone help me.
|