Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formula Columns
If for example I have the following formula:
=Sheet!$a1 and I want to copy it in the colums. I would like to have: =Sheet!$a1 =Sheet!$a2 =Sheet!$a3... etc. but by just dragging the cell I always get the same =Sheet!$a1 Any help ? thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formula Columns
Try this instead.
=INDIRECT("'Sheet2'!$A"&COLUMN(A1)) Note, this will only work when copying across (not down). HTH, Paul -- "Lauravila" wrote in message ... If for example I have the following formula: =Sheet!$a1 and I want to copy it in the colums. I would like to have: =Sheet!$a1 =Sheet!$a2 =Sheet!$a3... etc. but by just dragging the cell I always get the same =Sheet!$a1 Any help ? thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formula Columns
=OFFSET(Sheet1!$A$1,COLUMN(A1)-1,)
Drag/copy across. Gord Dibben MS Excel MVP On Fri, 28 Mar 2008 13:57:01 -0700, Lauravila wrote: If for example I have the following formula: =Sheet!$a1 and I want to copy it in the colums. I would like to have: =Sheet!$a1 =Sheet!$a2 =Sheet!$a3... etc. but by just dragging the cell I always get the same =Sheet!$a1 Any help ? thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Formula to additional columns | Excel Discussion (Misc queries) | |||
How do I copy columns when part of formula has another sheet in it | Excel Discussion (Misc queries) | |||
Copy sum formula to Other columns not working | Excel Worksheet Functions | |||
How do I set up a copy and paste formula with ascending columns | New Users to Excel | |||
how do i copy formula down columns avoiding hidden cells | Excel Discussion (Misc queries) |