auto numbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a purchase order template in excel, I want a new purchase order
number to appear each time the sheet is opened automaticlly, but I am having
trouble doing this. HELP IS NEEDED URGENT
 
You could use something simple like:

Sub Workbook_Open()
With Sheets("Sheet1").Range("A1")
.Value = .Value + 1
End With
ActiveWorkbook.Save
End Sub

---
Press ALT+F11, double-click on "ThisWorkbook" module, and
paste in the code. Save.

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

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

Purchase order with auto numbering 1
auto numbers 1
find and add function between sheets 2
should I be using Excel or Access 1
Page Number in cell 3
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel to Excel data exporting 1
Add numbers belonging to a vendor 4

Back
Top