Prev: MS Excel 2003 - Advanced Features Add-In
Next: Report using dates as a criteria
From: Rob on 4 Mar 2010 11:12
I'm trying to copy the contents from one sheet to another. My objective is
take data that is in a row and move it into a column on another sheet.
EX. move c2 in sheet a to k2 in new sheet. Repeat this but skip from c2 to
c6 and place it in k3 etc.
From: Mike H on 4 Mar 2010 11:52
Rob,

This assumes the data your copying is on sheet 1. Put the formula in k2 of
another sheet and drag down

=INDEX(Sheet1!C:C,(ROW(A1)-1)*4+2)

Mike
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rob" wrote:

> I'm trying to copy the contents from one sheet to another. My objective is
> take data that is in a row and move it into a column on another sheet.
> EX. move c2 in sheet a to k2 in new sheet. Repeat this but skip from c2 to
> c6 and place it in k3 etc.
 | 
Pages: 1
Prev: MS Excel 2003 - Advanced Features Add-In
Next: Report using dates as a criteria