| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can we drag-copy cells from evry five row to every row
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can we drag-copy cells from evry five row to every row
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). JohnDiese wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can we drag-copy cells from evry five row to every row
******************************************
Many thanks to Dave and Martin : works fine and usefull ! Kind regards John ****************************************** "Dave Peterson" wrote: 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). JohnDiese wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to insert rows evry other time | Excel Discussion (Misc queries) | |||
| Can I fix a format so it doesn't change when I drag or copy/paste | Excel Worksheet Functions | |||
| Drag copy between worksheets | Excel Discussion (Misc queries) | |||
| In Excel, how can I stop the drag function to copy and not add? | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Linear Mode
