Skipping rows

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

Mike H

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

VBA Coding Help for Beginner 0
IF conditional to copy column from one spreadsheet to another 4
Dumb question alert! What program to use? 0
Dates In Excel 5
Excel help needed: Skipping cell without skipping cell reference 1
Pasting a cell into bookmarked table from excel vba 1
Using IF and VLOOKUP for range of cells 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top