Correstions, sorry, should be:

Put in D6: AV1

Then try in the starting cell, and copy down:
=IF('A-V Input'!B200,$D$6&"-"&ROWS($A$1:A1),"")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--