Copy values separated by a set number of columns

[Pablo]

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,

 

[FSt1]

hi
why not use formulas.
on sheet 2 you could put...
=sheet1!A3
=sheet1!C3
=sheet1!E3

not sure how you are planing to layout the data on sheet 2 but you could
place the fomula anywhere. and you can copy (drag) down.

a suggestion.
regards
FSt1