Solved: Cut a Long list in half and paste into a new Column

[JimS]

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

[stanleydgrom]

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

[JimS]

Stan (the "Man"),

Thanks, works perfectly...

Jim