asked on 11/6/2017

What do I add to my Mascro that will paste items in the next available row?

Here is my current macro:

ActiveCell.Range("A1:H1").Select
Selection.Copy
ActiveCell.Offset(1, -8).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(0, 8).Columns("A:H").EntireColumn.Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlToLeft

Microsoft Office Microsoft Excel VBA

Last Comment

Tracy

12/18/2017

Norie

11/6/2017

What exactly do you want to do?

Copy A1:H1 and paste to the next available row in column A?

Liz Nevers

11/6/2017

ASKER

Instead of event registration data being neat in rows, it is all in row 2 and repeats. So all 6 columns of Person 1's registration info runs from A2 to H2. Person 2's registration info runs from I2 to P2, and so on. So, I need to copy I1:P1 and paste it into the next available row in A:H

Norie

11/6/2017

So you vave data along row 1 and you want that to go down columns A:H?

Liz Nevers

11/6/2017

ASKER

Correct! I want all 125 registrants to have their data down the rows between columns A:H

ASKER CERTIFIED SOLUTION

Norie

11/6/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Tracy

12/18/2017

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Norie (https:#a42356984)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

broomee9
Experts-Exchange Cleanup Volunteer