Copy values separated by a set number of columns

  • Thread starter Thread starter Pablo
  • Start date Start date
P

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,
 
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
 

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

copy values separated by a set number of columns 1
Sum of multiple rows, based on date criteria, separate sheets... 0
Counting with multiple criteria in separate Columns 6
Loop ? again 11
Multiple conditions 2
Scrabble Value calculation for Welsh words 0
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
Results don't macth. 2

Back
Top