automatically delete empty rows when transfer data from userform to sheet1

[abdelfattah]

hi, everyone
i need code automatically delete empty rows when transfer data from userform to sheet1
i have userform when i fill data it does transfer data to sheet1 i would delete rows from after lastrow contains data without effect the values of others cells the basic of range beginning from a19:e35 in my case when i fill data in range from a19:e22 after this should delete from a23 :e30 don't delete range a33:e35 because linked of value other lastrow contains data in this case rows a22:e22

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-rows-when-transfer-data-userform-sheet1.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.