| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cells down a column (in order) to across a row (same order??
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy cells down a column (in order) to across a row (same order??
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 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| copy the order number to corresponding cells | Excel Discussion (Misc queries) | |||
| Copy cells in a determined order | Excel Discussion (Misc queries) | |||
| I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Hybrid Mode
