| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert rows
Ok, A1 is empty and B:1:G1 is filled with data. A2:G2 is
filled with data. In plain English, this is what I want to do. If the cell on top of the cell that is filled with data is empty, it will insert 2 rows on top. I just have several data that I need to insert rows inbetween particular item. A B C D E 1 M012 Martin Computer 90 2 Math 75 3 History 65 4 Science 100 6 E013 Earn Go Computer 100 7 Math 93 8 History 70 9 Science 85 I want to insert 2 rows in between 4 and 6 automatically.. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
| How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
| Insert rows: Formats & formulas extended to additonal rows | Excel Worksheet Functions | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
| How do i insert of spacer rows between rows in large spreadsheets | Excel Discussion (Misc queries) | |||
Threaded Mode
