Hi all,

I need some code to automate a laborious process that has to be done
every month to prepare the data for input as a text file into a
databse.

Here's the deal.....

I have a spreadsheet that has about 100 columns, and several hundred
rows.

Column 1 contains dates, sequenced by month. The rest contain numbers
(Production data)

Row 1 contains well names, with row 3 having the production data for
that month, per well.

What I need to do is copy and paste the info into another spreadsheet,
but it has to be separated by month, and be copied in blocks of 10
columns.

Very roughly the data starts off looking a bit like this (I've reduced
it to just a few of the columns for clarity and hope the formatting
holds in this message).....

Date Well1 Well2 Well3
Well4 ....Welln
Jan-08 0 20 30
40 .....
Feb-08 20 30 30 50
Mar-08
and needs to look like this.....

Jan 08
Well1 Well2
0 20
Well3 Well4
30 40
Feb-08
Well1 Well2
20 30
Well3 Well4
30 40

and so on down to the last date in column A.

I hope this is clear enough and that someone out there can help!

Many thanks in advance,

Phil