Can we drag-copy cells from evry five row to every row
Hi John,
Try this in A2 of your destination sheet
=INDEX(Source!A:A,ROWS($1:1)*5)
HTH
Martin
"JohnDiese" wrote in message
...
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
|