View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Project Master The Project Master is offline
external usenet poster
 
Posts: 4
Default 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.