Thank you so much JBeaucaire!
The code works great in a new workbook and if the "Deleted" sheet is not protected.
In my workbook, where I currently run another code, I had to make the following modifications, by adding your code:
Now, column for inserting "delete" is R:R and not M:M.
Testing the code, I noticed that the row in the original sheet remains with all cells blank (no formulas, no data validation, no nothing). I'd like the code to move in the "Deleted" sheet all the inputs (values only, I don't mind) from the initial row, but keep all the formulas, data validation, conditional formatting, etc intact in the initial row. Do you think it's possible?
Thanks again!
Bookmarks