Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy columns with order reversed
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy columns with order reversed
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 On Dec 11, 7:04 pm, Karra wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is reversed conditional formatting? | Excel Worksheet Functions | |||
columns reversed | Excel Worksheet Functions | |||
blank sheet excel columns are reversed r to l.Why? | Excel Discussion (Misc queries) | |||
reversed columns | Excel Discussion (Misc queries) | |||
Why are my columns and rows reversed when I open Excel | Excel Discussion (Misc queries) |