Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto numbering
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 |
#2
|
|||
|
|||
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 -----Original Message----- 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 . |
#3
|
|||
|
|||
Hi
see: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Frank Kabel Frankfurt, Germany "Tricky Nicky" <Tricky schrieb im Newsbeitrag ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Resizing of Pie Charts | Excel Discussion (Misc queries) | |||
Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
auto save in office excel 2003 | Excel Discussion (Misc queries) | |||
How can I auto update a graph? | Charts and Charting in Excel |