Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel macro/funcion insert row if
I need to insert rows in my excel spreadsheet under certain conditions.
Specifically, I should always have six lines with certain data in it. But sometimes I have less. In order to process the data further I then need to insert empty rows. For example, I might have 1456 1234 1456 1345 1789 2479 2567 then I need: 1456 1234 1456 1345 1789 1 2479 2567 2 2 2 2 Does anyone know how to tackle this? Thanks a lot! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel macro/funcion insert row if
I can think of lots of ways but you need to provide some context - for
example: where is the data coming from, are you using macros to insert the rows what are you trying to achieve. Regards RegMigrant "dersonnenach" wrote: I need to insert rows in my excel spreadsheet under certain conditions. Specifically, I should always have six lines with certain data in it. But sometimes I have less. In order to process the data further I then need to insert empty rows. For example, I might have 1456 1234 1456 1345 1789 2479 2567 then I need: 1456 1234 1456 1345 1789 1 2479 2567 2 2 2 2 Does anyone know how to tackle this? Thanks a lot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
offset, transpose funcion | Excel Worksheet Functions | |||
INSERTAR FUNCION MES | Excel Worksheet Functions | |||
If funcion on big formula | Excel Worksheet Functions | |||
funcion de distribucion empirica | Excel Worksheet Functions | |||
how do see add-in a funcion belongs to | Excel Discussion (Misc queries) |