| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a fixed number of lines between a varying range of cells
I am sent a continuous range of client IDs for a report every month that will
vary in length each month. In between each client ID I need to insert 6 empty rows. Does anyone know how this can be done through the use of a macro? I don't know how to get excel to put 6 rows between each original cell for the full range of data that will change each month. Any help would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I determine which data in a range add up to a fixed number? | Excel Worksheet Functions | |||
| How do I insert a decimal into a fixed number? | Excel Discussion (Misc queries) | |||
| Insert a fixed number of characters | Excel Programming | |||
| concatenate with a varying range of cells | Excel Worksheet Functions | |||
| divide all numbers in range by a fixed number | Excel Discussion (Misc queries) | |||
Threaded Mode
