PDA

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



JimS
01-23-2009, 09:38 PM
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
01-24-2009, 07:18 AM
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
01-24-2009, 11:06 AM
Stan (the "Man"),

Thanks, works perfectly...

Jim