Hello,

i need to make a loop on the first column (i have data from row3 to row 1987654), and if cell contains create, then add two rows above it and two formulas

<tbody>

</tbody>

¿can you help me?

sorry it wasn´t very well explained.

i need to do the following if in column a it finds create, then insert two rows above and in the first row add the first formula and in then second, the second formula.

thanks

i need to make a loop on the first column (i have data from row3 to row 1987654), and if cell contains create, then add two rows above it and two formulas

- =CONCATENATE("formula1";R[4]C[1])
- =CONCATENATE("formula2";R[2]C[1])

A | B | ||

1 | |||

2 | |||

3 |
<tbody> </tbody> | ||

4 |
<tbody> </tbody> | ||

5 |
<tbody> </tbody> | ||

6 |
<tbody> </tbody> | ||

7 |
<tbody> </tbody> |

<tbody>

</tbody>

¿can you help me?

*EDIT:*sorry it wasn´t very well explained.

i need to do the following if in column a it finds create, then insert two rows above and in the first row add the first formula and in then second, the second formula.

thanks

Last edited by a moderator: