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.

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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