Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
You could add a 1 to Sheet1!A1 each time the workbook is
opened. Press ALT+F11, double-click the "ThisWorkbook" module under ViewProject Explorer and paste in: Sub Workbook_Open() With Sheets("Sheet1").[A1] .Value = .Value + 1 End With ActiveWorkbook.Save End Sub -- HTH Jason Atlanta, GA -----Original Message----- I created a template for a purchase order in Excel. Everytime someone opens the template, I would like one cell to be automatically numbered in a sequential pattern. That way each time the template is used, it will have it's own unique number that will be used to identify it. Does anyone know if this is possible for Excel 2000? Thanks! . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions | |||
how to set up a column in excel so it can auto number | Excel Discussion (Misc queries) | |||
Email template from excel | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |