Skipping rows

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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

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

IF conditional to copy column from one spreadsheet to another 3
COUNT rows on external sheet if between date range 3
Dependent drop down dynamic range formula, off sheet. 7
Excel Move or Copy Stopped Working? 0
transpose data 3
***Help on writing a vba code 12
Help IfBlank use data from next cell 9
Saving sheet data to another sheet automatically 7

Back
Top