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
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