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

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

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?

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?

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