| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste data in different sheet but skip rows.
Hi,
I would like to copy a column of names from one sheet to another but would like to paste the data into every second row. i.e. Sheet1!A7 goes to Sheet2!A7 ; Sheet1!A8 goes to Sheet2!A9 ; Sheet1!A9 goes to Sheet2!A11 etc. I have seen similar posts / answers using the INDEX formula but can't work out how to make it work for me! Any help would be much appreciated! Thanks Carmel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste data in different sheet but skip rows.
Carmel,
In sheet2, cell A7, enter =IF(MOD(ROW(),2)=1,INDEX(Sheet1!$A$7:$A$5000,ROW(A 2)/2),"") and copy down as far as you need. HTH, Bernie MS Excel MVP "CarmK" wrote in message ... Hi, I would like to copy a column of names from one sheet to another but would like to paste the data into every second row. i.e. Sheet1!A7 goes to Sheet2!A7 ; Sheet1!A8 goes to Sheet2!A9 ; Sheet1!A9 goes to Sheet2!A11 etc. I have seen similar posts / answers using the INDEX formula but can't work out how to make it work for me! Any help would be much appreciated! Thanks Carmel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste data in different sheet but skip rows.
Wow, that was fantastic! Thanks a million!! You have saved me hours of work!
Now all I need to do is work out How that works! :-) "Bernie Deitrick" wrote: Carmel, In sheet2, cell A7, enter =IF(MOD(ROW(),2)=1,INDEX(Sheet1!$A$7:$A$5000,ROW(A 2)/2),"") and copy down as far as you need. HTH, Bernie MS Excel MVP "CarmK" wrote in message ... Hi, I would like to copy a column of names from one sheet to another but would like to paste the data into every second row. i.e. Sheet1!A7 goes to Sheet2!A7 ; Sheet1!A8 goes to Sheet2!A9 ; Sheet1!A9 goes to Sheet2!A11 etc. I have seen similar posts / answers using the INDEX formula but can't work out how to make it work for me! Any help would be much appreciated! Thanks Carmel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can copy only the unhide rows and paste it another sheet | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How to paste data over the hidden rows in a sheet with a filter | Excel Discussion (Misc queries) | |||
| paste formula and skip blanks | Excel Discussion (Misc queries) | |||
| copy paste formula to skip rows | Excel Worksheet Functions | |||
Linear Mode
