Hi

I was hoping someone could help me with this... I have used it before - but
obviosuly did not write the formula myself!-
I wanted to insert a column which automatically fills in a reference code
for new purchase orders to be sent out.

So if an entry is made in coulmn B1 a reference name is created e.g. PO1,
which would appear in cell A1, and if a new entry is added later in to cell
B2, then refernce PO2 would appear...

Can anyone help??

Many thanks

Martha