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

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
 
G

Gord Dibben

Enter in A1 and copy down as far as you wish.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spurious Formula Omits Adjacent Cells 2
Auto fill Adjacent cells 7
Find duplicate, but only if an adjacent cell is identical 2
Add cells on two adjacent rows but non-adjacent columns 15
changing multiple column references in a formula 5
Formula to Increment a number upon a match in an adjacent cell 9
count no. of times a character occurs in a cell 2
how to fill in names in cells automatically 2

Top