return next # in sequence

  • Thread starter Thread starter matthew
  • Start date Start date
M

matthew

I am creating a list of purchase orders and all of the
POs have a prefix. How do I automate the suffix number to
be added to the prefix?

Thanks,
Matthew
 
one way:
use Autocorrect to change an unlikely string to your
prefix. For example, if your prefix is RPXXL
in Autocorrect set qq to change to RPXXL
to input po "RPXXL 478831"
input
"qq 478831"

the cell content will change to the po above.
 
Hi Matthew,

Not sure if my previous response made it, so here it is
again. Try this formula:

(Prefix is in Cell A1 = "2225")
(Purchase Order number in Cell B1 = A1 & "-" & C1
"2225-150")
(First suffix is in Cell C1 = "150")

Formula in Cell B2 =$A$1 & "-" & (RIGHT(B1,LEN(B1)-5)) + 1

Copy the formula in Cell B2 down and you will get the
following Purchase Orders:

2225-150 (B1)
2225-151 (B2)
2225-152 (B3)
2225-153 (B4)

Hope that helps.

Regards,
James S
 
Back
Top