copy cells down a column (in order) to across a row (same order??

copy cells down a column (in order) to across a row (same order??

Post by VGFtcGE » Fri, 05 Dec 2008 23:39:01


I want to copy cells from a column (C1:C10) to a row (D10:M10) without having
to go into every formula to change it (the currently formula is =$C10) as i
have to change the number value.
 
 
 

copy cells down a column (in order) to across a row (same order??

Post by Gord Dibbe » Sat, 06 Dec 2008 01:23:14

In D10 enter =INDIRECT("C"&COLUMN(A1))

Copy across to M10


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 06:39:01 -0800, Tampa9 < XXXX@XXXXX.COM >