| 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 |
| 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 | |||
Threaded Mode
