Copying Blocks of Cells

[phil]

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

 

[Simon Lloyd]

I'm confused with your explanation of what you have in columns an
rows?, do you meant that every block of 4 rows is a separate date an
data?, can you explain any better

If not you can join the forum below for free where you can add
workbook to your post so we can see your structure and help you with i
better, if you do join make sure you post in this thread (link show
below) so that folk who have been following it or helping can stil
continue to do so

Hi all

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

Here's the deal....

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

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

Row 1 contains well names, with row 3 having the production data fo
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 1
columns

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

Date Well1 Well2 Well
Well4 ....Well
Jan-08 0 20 3
40 ....
Feb-08 20 30 30 5
Mar-0
and needs to look like this....

Jan 0
Well1 Well
0 2
Well3 Well
30 4
Feb-0
Well1 Well
20 3
Well3 Well
30 4

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

Phi

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com