| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatically inserting rows
Hello all,
I have a group of data in a worksheet. Is there a formula that I can use to insert a blank row that separate data that are alike? Here's my sample data: PO/NO Quantity 1. 6135008885 10500 2. 6135008885 4284 3. 6135008885 3896 4. 6135008886 4320 5. 6135008886 3780 6. 6135008886 10500 7. 6135008887 10500 8. 6135008887 4032 9. 6135008887 3868 How can I insert a blank row between row's 3 and 4 and row's 6 and 7? Help appreciated. Cheers, Wendy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Inserting Rows w/formulas question | Excel Worksheet Functions | |||
| inserting rows through external data source | Excel Discussion (Misc queries) | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
Threaded Mode
