Mike,

I don't know about copying but you could do this with a formula. I'm not
sure if this is the most efficient formula\method, but it will work.

Example:

Sheet1 has the data you want to put in another sheet. The data is in columns
A thru whatever.

Sheet2 is the sheet you want the data in.

In sheet two, somewhere out of the way (off to the right, or way down),
create a lookup table like the following:

col1 col2
1 1
4 -2
7 -4
10 -6

etc, all the way down to suit your needs. You can fill down to make this
very fast after you have done the first couple of lines (in the second
column, make sure you don't select the "1" entry when you fill).

You could create this table in another sheet also and give it a name if you
like.

Then in sheet2, in cell d2 enter the following formula:

=OFFSET(Sheet1!D2,,VLOOKUP(COLUMN(),"Lookup Range",2,FALSE))

Where you substitue your range (be sure to use absolute references) or range
name for "Lookup Range".

Then copy this formula to each of the appropriate columns (d,g,j,etc.)

Then copy the formulas down as far as you need.

There might be mathematical equation you could stick in there instead of
using the lookup range, but I'm tight on time and my math mind is gone by
this time.

Hope that helps.


"Mike_can" wrote:

Hi

I'd like to copy the values from columns that are together (a,b, c, d...) in
another spreadsheet on separate columns (a, d, g, j) is there a easy way to
do it?

Thanks a lot

Mike