copy columns with order reversed

[Karra]

I have 10 columns "column 1" .. "column 10" from left to right in a
source sheet. I want to copy them to another sheet such that the
columns are now ordered "column 10" .. "column 1" from left to right.

It feels like this should be very easy to do; but for some reason I
have not managed to figure out the solution. Can someone point me in
the right direction?

 

[vezerid]

You can use the OFFSET function. Say your data start in Sheet1!D7 and
extend to column M, say until M123. In the destination sheet, wherever
you want your data to start:

=OFFSET('Sheet 1'!$D7,0,COLUMN('Sheet 1'!$D7)+COLUMNS('Sheet 1'!
$D7:$M123)-COLUMN('Sheet 1'!D7)-1)

You can copy this formula down and accross, after modifying the cell
references (but not the $$).

HTH
Kostis Vezerides