auto numbering for different vendor

Hi,

i want to create simple PO with auto numbering for PO number, the format number is: N12001 - 1 or 2 or 3 or 4
12 is for the year
001 is for auto number
1-4 is for certain vendor for instance 1 - company A, 2 is company B and so forth

I have no idea about vba, but for simple method like auto number 001,002 i can make the simple code, but for this method N12001-x , totally blank

If ThisWorkbook.Name = "test.xls" Then
If Format(Left(A1, 3)) Then Format (Left(A1, 3)) & Format(Right(A1, 3)) + 1

Appreciate to your help guys..

onestar

Please add some further detail...

If ThisWorkbook.Name = "test.xls" Then

Is there one wbook to convert or more than one?

Your snippet suggests you want to overwrite each company name in col "A". Is this how you want to finish up?

Please Login or Register  to view this content.