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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF function and cell /sheet reference 3
Fill formula down for cells 74 rows apart 3
Auto Generate Sorting table(empty cell)?? 1
Tracking using =sumproduct 3
Excel Copy COUNTIF while retaining reference 7
Hyperlink via indirect cell reference 8
How do I copy formulas down a sheet using increments? 1
HYPERLINK, MATCH functions 3

Top