Select Any Cell and Copy Entire Row, Then Paste Data to New Worksheet

[RoroBear]

Hello Everyone,
I have the below code. When I click the command button an inputbox appears and I’m able select a range of cells of my choosing. Then when I click OK, it pastes it to another sheet (Sheet2). Although it works, I’d like some help modifying it. I want to do away with the inputbox altogether. I want to just select any cell in a row and copy the entire row. Then when I click the command button, go to sheet2 and paste the data to last empty row of sheet2. And last, delete the copied row from sheet1. I’ve attached the file for further clarity. If anyone could help, I’d really appreciated it.

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[RoroBear]

My apologies, profile has been updated to reflect current version of excel (Excel 2016 MSO 32 bit)

[Pepe Le Mokko]

Np. Thank you

[RoroBear]

hello everyone,

Still haven't been able to find a solution to this problem. Still looking for some help if anyone has any ideas. thank you as always.

v/
Roro