If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Increment Value By 1 Each Time Spreadsheet is Opened
I am creating a purchase requisition form in Excel and when users open
the spreadsheet I want the requisition # incremented by 1 so we have unique requisition #'s each time a requisition form is completed. Is there a way to accomplish this in Excel? Thanks for your assistance. |
#2
|
|||
|
|||
Increment Value By 1 Each Time Spreadsheet is Opened
This workbook will be a true Template(*.xlt)?
For sequencing numbers see John McGimpsey's site. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben MS Excel MVP On Thu, 3 Jun 2010 15:55:46 -0700, The Project Master wrote: I am creating a purchase requisition form in Excel and when users open the spreadsheet I want the requisition # incremented by 1 so we have unique requisition #'s each time a requisition form is completed. Is there a way to accomplish this in Excel? Thanks for your assistance. |
#3
|
|||
|
|||
Increment Value By 1 Each Time Spreadsheet is Opened
It may be better to put in a before_print macro
-- Don Guillett Microsoft MVP Excel SalesAid Software "The Project Master" wrote in message ... I am creating a purchase requisition form in Excel and when users open the spreadsheet I want the requisition # incremented by 1 so we have unique requisition #'s each time a requisition form is completed. Is there a way to accomplish this in Excel? Thanks for your assistance. |
Thread Tools | |
Display Modes | |
|
|