automated number sequence

[vicaima]

Hi all

this will probably be very simple for someone but i could do with knowing how to program an automated number sequence

I have a quote log and the numbers we generate are like this ECQ123/12

This all means something to us - ECQ = electronic inquiry - 123 - the quote number and the /12 means 2012 - as we archive all of the quotes

I would like excel to generate the sequence in the log as follows in a column

ECQ123/12
ECQ124/12
ECQ125/12
ECQ126/12

how do i do this ?
please help as will be making our lives easier if the quote number generates itself

cheers
James

[martindwilson]

="ECQ"&TEXT(ROW(A1),"000")&"/12" change row(a1) to whichever number you want to start at EG ROW(A123)
fill down as far as you need then copy paste back over itself as paste special values

[benishiryo]

hi James. assuming your data starts from B2, try:
="ECQ"&122+ROWS(B$2:B2)&"/12"

or better still if you have a date on the same row (say in D2), so that the years change:
="ECQ"&122+ROWS(B$2:B2)&"/"&RIGHT(YEAR(D2),2)

[Kevin UK]

Hi vicaima

Another version, assuming your data is in A1 and copy down.

="ECQ"&ROW(A1)+122&"/"&TEXT(TODAY(),"yy")

[vicaima]

All of those worked great thanks very much for all your help
you have saved us loads of time !