Worksheet_change and rows overlapping

[fotonika]

Hello everybody,

I am trying to make a sort of CRM file to ease my job. I have this file with four different Sheets: Suspect / Prospect / Attivi / Brand
Some columns are filled with dropdown menu. When in the cell Esito Chiamata (M1), in Suspect sheet, "ok" is selected, the row must be moved to Prospect sheet.
When in the cell Proposta Accettata (L1), in Prospect sheet, "ok" is selected, the row must be moved to Attivi sheet.
I am not very good with VBA, it's my first time using this language, so I tried to copy some code I found online and edited it and somehow it works but still has some problems:
The rows moved between sheets are not placed after the last used row, but they will overlap every time. I need them to be moved to the last empty row of the sheet. Plus, I every new row of the sheets must have the same data validation (dropdown menu basically) as the row above, I added a macro and a button (Aggiungi riga button in P1), but it will add one row at a time, I would need to add multiple rows with same formatting and validation.

This is the code for Worksheet_change:

Please Login or Register  to view this content.

Thank you so much
M

[AlphaFrog]

Suspect worksheet code module

Please Login or Register  to view this content.

Prospect worksheet code module

Please Login or Register  to view this content.