Hi All,

As this is my first post I will give a bit of an introduction first! I have been playing with excel macros over the last few months to make some of my reporting and data analysis tasks easier and more efficient. With the help of this forum I have had some great success while learning a lot as I go.

I have searched high and low for a way to split a table/column in half but cannot find anything. Can anyone shed any light on this?

Basically I have a table that i need to split in half and put each half in a new sheet.

So far I have been unable to find a way to make excel find and go to the middle of the range of cells or column.

Thanks in advance