| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows using a list of numbers
I have a spreadsheet with hundreds of rows and six columns (7 with total).
Once completed I need to insert a row for each column with data in. Each row is a seperate project:e.g. A B C D E F Total Project 1 £50 £100 £200 £400 £750 This row would need 4 blank rows inserting below the project number. I can count the number of occupied cells, but cannot work out how to insert rows using this info. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
| lock a total row below a list & allow inserting in the list? | Excel Worksheet Functions | |||
| Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
| How to auto insert rows in a list of numbers | Excel Discussion (Misc queries) | |||
| Inserting rows | Excel Discussion (Misc queries) | |||
Threaded Mode
