Is it possible to have a simple purchase order excel sheet which allows me to generate a unique numbering system. I would also need to export the information to a database which stores p.o. number, date created, and the amount ordered.
I am not very familiar with SQL or Access so i hope it is possible to do something simple through excel.
Thank you for any help you may be able to give me.
|Check out our Excel VBA Resources|
What you could do is something like this:-
Say you're PO number is in cell A1 of your worksheet you could use a little VBA code to increase this number by 1 each time a new PO is requested.
Start by opening the VB editor (Alt+F11), then click View, Project Explorer (it may already be visible).
In the project explorer double click the ThisWorkbook icon associated with your PO workbook.
You'll be presented with a blank code module. Now assuming your sheet name is 'PO'. Try this code:-
Private Sub Workbook_Open()
Sheets("PO").Range("A1").Value = Sheets("PO").Range("A1").Value + 1
This means that the workbook needs to be closed and then opened again if you want to create another purchase order. You could have a button on your worksheet and then assign a similar macro to the one above.
Yes, that's great for the numbering. Is there anyway of recording the date and the po description in another file?