Making 4 columns from 2 columns

[rlnye]

In Excel 2000, a spreadsheet I use extracts data in two columns (column A1 is numeric and B1 in descriptive text) the number of rows in the two columns varies...sometimes just 6 rows in the two columns othertimes 32 rows. What I need to do is if the number of rows in A1:B? is over 15, divide the number of rows in half and copy the bottom half to D1. In other words if the number of rows is A1:B24...copy the bottom 12 rows A13:B24 to D1. If I need to use VB code can someone help with the code...I'm a new comer to Excel. Thanks

 

[rlnye]

Andrew, it makes two rows if the number of rows is 15 or less. What I need to do is make two rows only if there is 15 or more rows...and if less than or more than 15 rows, to continue to run the VB code under your code.

Thanks for taking the time to help.

 

[Andrew Poulsom]

Oh, my fault in removing the Exit Sub! The test needs changing using End If.

If Source.Rows.Count > 15 Then

By the way you only need to press Submit once. I find that the posting has gone even if there is a timeout.

 

[rlnye]

Andrew, I got it to work...I just altered the following line..."If Source.Rows.Count >= 15 Then" and left the code under it, and then added another line..."If Source.Rows.Count <= 15 Then" and added what I wanted it to do along with an End If.

Thanks again for all your help...without it I still would be losing brain cells trying to figure it out.