jump 4 column

[mabaud]

i have datas in colomn a, d, g, j(jump 3 column)
in an other worksheet, i would like those datas to be next to each other in column a,b,c,d.
is there a formula that i can write in a and copy and paste in b,c,d?
thanks for your help

 

[Mark W.]

On 2002-04-17 08:53, mabaud wrote:
i have datas in colomn a, d, g, j(jump 3 column)
in an other worksheet, i would like those datas to be next to each other in column a,b,c,d.
is there a formula that i can write in a and copy and paste in b,c,d?
thanks for your help

Copy/Paste is a command -- not accomplished by a formula. Have you tried Control+Clicking on columns A:A,D:D,G:G and then Copy/Paste on column A:A of another worksheet?

 

[Chris Davison]

On 2002-04-17 08:53, mabaud wrote:
i have datas in colomn a, d, g, j(jump 3 column)
in an other worksheet, i would like those datas to be next to each other in column a,b,c,d.
is there a formula that i can write in a and copy and paste in b,c,d?
thanks for your help

starting in A1 on sheet 2, this will copy sheet 1 cell A1 and "paste" it across skipping 3 columns each time :

=INDIRECT("Sheet1!R"&ROW(1:1)&"C"&(COLUMN()*2+COLUMN()-2),0)

I assumed you'd want to then copy down also, which this takes care of with "ROW(1:1)"