| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy reference cell with alternate column
I have to get data from difference Sheet but in difference column, so say in
sheet 2 cell A1,Formula: =Sheet1:A1, but in Sheet 2 cell B1, formula: =Sheet1:C1,in Sheet 2 cell C1, formula: =Sheet1:E1 Any shurtcut to copy such formula? Thank for help. -- Aclim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy reference cell with alternate column
Is there any logic behind selecting cells in sheets?
"aclim" wrote: I have to get data from difference Sheet but in difference column, so say in sheet 2 cell A1,Formula: =Sheet1:A1, but in Sheet 2 cell B1, formula: =Sheet1:C1,in Sheet 2 cell C1, formula: =Sheet1:E1 Any shurtcut to copy such formula? Thank for help. -- Aclim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy reference cell with alternate column
One way
In Sheet2 In A1: =INDEX(Sheet1!1:1,COLUMNS($A:A)*2-1) Copy across as far as required to return Sheet1's A1, C1, E1, ... You can then fill down as well, to return Sheet1's A2, C2, E2, ... if desired Pl mark responses which help by clicking the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "aclim" wrote: I have to get data from difference Sheet but in difference column, so say in sheet 2 cell A1,Formula: =Sheet1:A1, but in Sheet 2 cell B1, formula: =Sheet1:C1,in Sheet 2 cell C1, formula: =Sheet1:E1 Any shurtcut to copy such formula? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy reference cell with alternate column
Hi Max,
Thank a lot! your formula work perfectly! -- Aclim "Max" wrote: One way In Sheet2 In A1: =INDEX(Sheet1!1:1,COLUMNS($A:A)*2-1) Copy across as far as required to return Sheet1's A1, C1, E1, ... You can then fill down as well, to return Sheet1's A2, C2, E2, ... if desired Pl mark responses which help by clicking the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "aclim" wrote: I have to get data from difference Sheet but in difference column, so say in sheet 2 cell A1,Formula: =Sheet1:A1, but in Sheet 2 cell B1, formula: =Sheet1:C1,in Sheet 2 cell C1, formula: =Sheet1:E1 Any shurtcut to copy such formula? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy reference cell with alternate column
Welcome, Aclim
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "aclim" wrote in message ... Hi Max, Thank a lot! your formula work perfectly! -- Aclim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | Excel Discussion (Misc queries) | |||
| Copy formula down a column does not use correct cell reference | Excel Discussion (Misc queries) | |||
| Column Reference Copy | Excel Worksheet Functions | |||
| Copy Cell or Column without advancing formula reference? | Excel Discussion (Misc queries) | |||
| Select alternate rows to copy | Excel Discussion (Misc queries) | |||
Hybrid Mode
