If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|