Copy & paste then delete and then paste on last row of different sheet

[RoroBear]

Hello All!

If anyone can help with the below code, I’d really appreciate it. What the code does is prompts the user via an inputbox to select and copy a range of cells on Sheet1, then when the user clicks OK it pastes the selected range to the last row on Sheet2. I’d like to add an additional step in the process. Once the user clicks OK, the selected range on Sheet1 is deleted and then the user is taken to Sheet2 where the selected range is pasted on the last row. Below is the code, and workbook is attached. Thank you very much for the support!

v/
roro

Please Login or Register  to view this content.

[karmapala]

Maybe you can try to add these lines:

Please Login or Register  to view this content.

After this line

Please Login or Register  to view this content.

\

Not tested.

[jolivanes]

This would be my preference.

Please Login or Register  to view this content.

[RoroBear]

To All,

Both code work very well and I'm grateful for the speedy response. Thank you again for the support!

v/
roro