| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank rows between copied rows
hi, if i have 10 rows of data and would like to copy them into a new sheet
with a condition of 4 blank rows of each row data, so the second will be in the $th row, and so on, how can i do this?? exmp: before after 12345 Andrew XXX YYY 12345 Andrew XXX YYY 12356 Andy TTT UUU - 12675 Adro NNN MMM - 13452 Budi LLL OOO - 14567 Lory MMM PPP 12356 Andy TTT UUU etc.. Any help would be appreciated.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Listing data without blank rows | Excel Worksheet Functions | |||
| Insert blank rows repeatedly between every data row in Excel | Excel Discussion (Misc queries) | |||
| combine speadsheets leaving no blank rows on master page | Excel Discussion (Misc queries) | |||
| how do I print grid lines for blank rows | Excel Discussion (Misc queries) | |||
| Blank Rows | Excel Discussion (Misc queries) | |||
Threaded Mode
