Macro to Copy and Paste to new sheet

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Im not great with excel macros and VBA so bear with me.

I want to create a macro that will Copy and then paste the current highlighted selection onto a new sheet.

I have this code -

Sub CopySelection()


Selection.Copy Sheets("Approved & Completed").Range(Selection.Address)


End Sub

Which copies and pastes the selection into the same range on the new sheet (Approved & Completed)

Problem is once this have been done the user then deletes this record from the first sheet and new info is put in it's place, which, when copied across overrites what is currently there.

What i want is a macro that copies the selection to the new sheet into the next empty row.

Sorry if this is confusing, thanks in advance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Not enough information to give you a good answer. But it seems that you need to find out the last used row