[Help] Autofill in collum Help

[gigilal]

Hi, I am working in a excel sheet and trying to make it abit more easyer to use formyself and other people.

But the dot in the I is missing and I can't figure out how to get it to work.

My plan is to: - each time I am done in Collum "K" - 2 I want excel to create a new number for me in "A" - 2,3,4 and so on.

A link to the excel sheet can be seen here: http://www.upload.ee/image/5455108/Excel.png

So The numbers should go from 2016/100 - Next line 2016/101 - Next line 2016/102 - Automatic so I do not need to Mark 2016/100 and pull it down.

Is this possible?

Thank you

[Beamernsw]

Place the formula below in cell A2 and copy down. As you put data in column K, a new number will appear.

=IF(K1="","","2016/"&ROW()+99)

[LeoTaxi]

With this

Please Login or Register  to view this content.

Kind regards
Leo