| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically insert rows
I have around 50,000 rows of data down each sheet.
These are made up of a contiuous series of approx 4000 blocks of data. The blocks of data vary between 2 and 30 rows deep. What I want to do is insert a blank row after each block of data. Manually, over 6 sheets, I would have to do around 24,000 copy/pastes and this isn't practical. Does anyone know how it can be set up to run automatically?? Any helpful suggestions/comments would be appreciated and I'm familiar with Excel macros - if that's at all useful. Thanks. Colwyn. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically insert rows with formula | Excel Worksheet Functions | |||
| Automatically Insert New Rows | Excel Discussion (Misc queries) | |||
| How can I set excel to automatically insert rows | Excel Worksheet Functions | |||
| Automatically insert/delete rows to be x apart | Excel Discussion (Misc queries) | |||
| how do you have rows automatically insert in excel? | Excel Worksheet Functions | |||
Threaded Mode
