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,