Copy reference cell with alternate column

A

aclim

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

Max

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
 
Top