How do you generate a PO number in an excel spreadsheet?

It is in macro (Did you heared of VBA?)

You will need to create the macro that will run at each start and adding new value to the old one.

It is something like this

Paste these lines in the ThisWorkbook object in your VBA window (Open excel, then press ALT+F11)

Private Sub Workbook_Open()

Starting

End Sub

Sub Starting()

Sheet1.Range("B1").Value = VAL(Sheet1.Range("B1").Value) +1

End Sub

Assuming that the cell B1 in sheet "Sheet1 is the cell with PO number

mail me for more info

Enjoy my profile, I am the VBAXLMan

This Site Might Help You.

RE:

How do you generate a PO number in an excel spreadsheet?

I have a purchase order form in excel that I want to automatically generate a purchase order number every time it is opened. Is this at all possible and if so how would I do it?

OK, I looked (because you made me curious!) It's 65,536 Rows X 256 Columns. But I just read that the upcoming version of MS Office will have a greatly expanded Excel spreadsheet capability. Why would anyone heed 65,536 rows of data anyway? After all, you can always link worksheets and spreadsheets, if you have that much data to manage.

I know how to do this in access... don't know if excel can do it without using a macro. If you are familiar with macros see if you can write a macro to save the last PO number and then add 1 to it.

Enter ENC if the PO is encumbered and the encumbrance type is KETS. Otherwise this field must be blank.