View Single Post
  #2  
Old June 4th, 2010, 12:29 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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.