Tags Tags

Increment Value By 1 Each Time Spreadsheet is Opened

June 03rd, 2010 - 06:55 pm ET by The Project Master | Report spam
Help Create a new topic
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.
email Follow the discussionReplies 2 repliesReplies Make a reply

Replies

#1 Don Guillett
June 03rd, 2010 - 07:34 pm ET | Report spam
It may be better to put in a before_print macro

Don Guillett
Microsoft MVP Excel
SalesAid Software

"The Project Master" wrote in
message news:
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.

Similar topics

Make your own search :