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

's Computer Specifications

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.

's Computer Specifications

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 <(E-Mail Removed)>
wrote:

>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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
need order form to send copy of order to purchaser as well as the seller.	Tony M	Microsoft Frontpage	4	19th Jun 2008 02:10 PM
Re: how to have design column order be same as data sheet column order	John Spencer	Microsoft Access Queries	1	5th Dec 2006 09:43 PM
copy the order number to corresponding cells	tr2usa@yahoo.com	Microsoft Excel Misc	0	20th Oct 2006 01:50 PM
Copy cells in a determined order	pmarques	Microsoft Excel Misc	3	6th Feb 2006 04:15 PM
selection of cells within column while keepning same order	Frans	Microsoft Excel Misc	1	1st Aug 2004 02:07 PM