adding rows depending on cell value
 

i hope someone can help with my problem, im an excel dufus.

i have 3 colums, first column numbered 1-6, secong column with various
bits of data, third column i am using to help me add rows. if a "1"
appears in any cell in the 3rd column, i need it to add a row, and the
next number (ie 7, then 8, then 9) to the first column so it will look
like this:

1 AB 1
2 CD
3 DE
4 EF 1
5 FG
6 GH
7
8

other data will be inserted as needed in 7 & 8. My template only goes
to 6, i need provision for 7, 8 & 9 if needed.

TIA
Esra

adding rows depending on cell value
 

In A7: =IF(COUNT($C$1:$C$6)ROWS($1:1)-1,A6+1,"")

Copy down as far as required


" wrote:

i hope someone can help with my problem, im an excel dufus.

i have 3 colums, first column numbered 1-6, secong column with various
bits of data, third column i am using to help me add rows. if a "1"
appears in any cell in the 3rd column, i need it to add a row, and the
next number (ie 7, then 8, then 9) to the first column so it will look
like this:

1 AB 1
2 CD
3 DE
4 EF 1
5 FG
6 GH
7
8

other data will be inserted as needed in 7 & 8. My template only goes
to 6, i need provision for 7, 8 & 9 if needed.

TIA
Esra