Copy values separated by a set number of columns
 

I have a spreadsheet set up like this:


A B C D E F
1 2/13/2009 2/14/2009 2/15/2009
2 Plan Actual Plan Actual Plan Actual
3 W X Y Z AA AB

In a separate tab, I want to be able to group all the Daily Plan and Daily
Actual by date. Is there a way to copy the values that are separated by two
columns? In other words, copy the value for A3, then C3, and E3 for all the
planned results.

Thanks,

Copy values separated by a set number of columns
 

Yes. It depends if you want the results (from A, C, and E) in ONE cell on
the other sheet, or if you want them in separate cells on the other sheet.
But you can type = and then click over to the other sheet and select the
source cell (A3, for example). Then, to combine C3, you could (after
selecting A3) type & and then click on C3, then type & and then click on E3.

HTH

"Pablo" wrote:

I have a spreadsheet set up like this:


A B C D E F
1 2/13/2009 2/14/2009 2/15/2009
2 Plan Actual Plan Actual Plan Actual
3 W X Y Z AA AB

In a separate tab, I want to be able to group all the Daily Plan and Daily
Actual by date. Is there a way to copy the values that are separated by two
columns? In other words, copy the value for A3, then C3, and E3 for all the
planned results.

Thanks,

Copy values separated by a set number of columns
 

Posted this in response to one of your earlier repeat queries 3 - 4 days ago:
-----------------------
..copy the value for A3, then C3, and E3 for all the planned results.

Assuming source data as posted in Sheet1
In another sheet,
Put this in any start cell, eg in B2:
=OFFSET(Sheet1!$A$3,,ROWS($1:1)*2-2)
Copy down to return as desired

Click YES below if it helped
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---