Can we drag-copy cells from evry five row to every row


G

Guest

Hello,
Source data I want to copy are located on row 5, 10, 15, 20 and son on.
I want to use a formula like "=A5" to get these data to another sheet, but
located on every line :

SOURCE Destination Comment
@ Content @ content
A5 data1 A2 =Source!A5 that is data1
A10 data2 A3 =Source!A10 that is data2
A15 data3 A4 =Source!A15 that is data3

is is possible to fill jut A2 of the destination and then drag to get souce
data ?

Many thanks for help

John
 
Ad

Advertisements

D

Dave Peterson

How about putting this in A2 of the destination sheet:

=index(sheet1!a:a,(row()-1)*5)

And drag down until you run out of data (you'll start seeing 0's).
 
M

MartinW

Hi John,

Try this in A2 of your destination sheet

=INDEX(Source!A:A,ROWS($1:1)*5)

HTH
Martin
 
Ad

Advertisements

G

Guest

******************************************
Many thanks to Dave and Martin : works fine and usefull !

Kind regards

John
******************************************
 

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

Top