Try this amended set-up ..
In sheet: Front Sheet, as before,
we have a reference date in D6: 23-Dec-2005 (say)
In Sheet2,
we could put in A1:
=IF('Front Sheet'!D6="","","PF-"&TEXT('Front Sheet'!$D$6,"ddmm")&"00")
A1 will return: PF-231200
(If the date in 'Front Sheet'!D6 is cleared, A1 will appear blank)
And then put in A4 :
=IF($A$1="","",LEFT($A$1,LEN($A$1)-2)&TEXT(ROW(A1),"00"))Copy A4 down to say
A6
If A1 returns: PF-231200, A4:A6 will return:
PF-231201
PF-231202
PF-231203
And if the date in 'Front Sheet'!D6 is cleared, A1 will be "blank", and
A4:A6 will also appear "blank"
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"MikeR-Oz" wrote in message
...
Max, Thats great - a major step forward for for me. Now, can it instead
of
copying down or across and having it incrimentally add the next number or
be
individually setup as a template with each cell formula will say cell
A1
has the formula to give the PF-231200 and then cell A4 will populate or
have
formula that gives PF-231201 and cell A6 PF-231203 etc .
Mike