Automate adding in a reference number if the adjacent cell contains text...

  • Thread starter Thread starter mg
  • Start date Start date
M

mg

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
 
Enter in A1 and copy down as far as you wish.

=IF(B1="","","PO" & ROW())


Gord Dibben MS Excel MVP
 
Back
Top