VBA/Macro table issue

[Ejb123erok]

Hey,

I've attached my workbook (a similar one) and have the following issues that I would be grateful if I could get input on.

(please note: my Macro/VBA skills av very limited. However, the users this workbook is made for have even less skills)

As you can see from my sample workbook I have buttons. The first one adds a new row that copy and pastes the informations that is provided in the row above. I should add that the actual workbook have more columns but this is ofcourse easy to modify in the code. The second button cut&paste the row that is selected and puts it in the first empty row in sheet2.

What I need help with:

1. (priority!) If I press "Archive selected row" it works fine although I would like it to also delete the row so I don't have empty, archived, rows all of the sheet.

2. (not a priority!) I would like to have a button that deletes a selected row and that don't messes up the "number"-formula. For example: say I'm at A4 and press "add row". That works fine. However if I delete row 3 it messes up the number count.

3. Is there anyway to undo a button-pressing action? Let say a user archives a row but by misstake archived the wrong row and now wants to undo it. If I press undo or ctrl+z it doesn't undo it because (?) of VBA-programming.

Thank you for reading.