-
Solved: Cut a Long list in half and paste into a new Column
I have a long list of entries (in Columns A - D) that can vary in length.
I need a Macro that can "Cut" the list in half and paste the bottom half in Columns E - H (starting at Row 2).
I have no idea how to start to write this.
I thought I could use a =ROUND((COUNTA(A:A)-1)/2,0) to determine what row to begin the "Cut" at. The minus 1 is because there is a Header in Row 1 and this is also why I want to Paste the Cut starting at E2.
Any ideas?
As always thanks for any and all help...
Jim
-
JimS,
I am having trouble pasting an answer (have tried three times).
See the attached workbook "Cut a Long list in half and paste into a new Column - JimS - SDG.xls".
Then run the "MoveHalf" macro.
Have a great day,
Stan
-
Stan (the "Man"),
Thanks, works perfectly...
Jim
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules