I have a database I need to split equally in half by selecting every other
lead. Is there a quick way to Select the odd numbered rows(or even numbered
rows) of data(each row comprises one lead with it's info) cut those selected
rows and then paste them to a new workbook, and then collapse the empty cells
in the first worbook? It is a largfe list and I don't want to do this by
hand. Any help will be appreciated!

Thanks