Change cell value to next in series upon opening worksheet?

C

Connie

I have a protected form for users to fill out in Excel which has a
requisition # in the top right cell... I want the requisition # to change to
the next increment in the series each time the worksheet is opened... that
way, the next user automatically has the new requisition # on the form when
it is printed.

The Requisition # starts with M1000 and I want it to change to M1001 the
next time it is opened, then M1002 the next time... etc.

Thanks,
 
C

Connie

Thanks for the link... I am studying it... but, is there an easier way to
automate incremental updates of a cell (especially because it includes
letters, and the code looks like it requires a number format)?

Thanks again,
Connie
 
J

JE McGimpsey

The code can be modified to produce letters (e.g., concatenate "M" with
the sequential number).

That's the easiest method I know. I don't deliberately suggest
harder/more complicated solutions...
 
C

Connie

Thanks for your help.

JE McGimpsey said:
The code can be modified to produce letters (e.g., concatenate "M" with
the sequential number).

That's the easiest method I know. I don't deliberately suggest
harder/more complicated solutions...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increment Value By 1 Each Time Spreadsheet is Opened 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Increment Cell Value on Worksheet Change 6
Best way to create a workbook template that allows data entry and purchase order req to be created f 0
Password Cracker for Excel Worksheets/ Workbooks 9
Fill serie 4
vba to copy data from sale receipt to next available column in aninventory worksheet 0
Cell values to an array, then array transpose to another workbook 8

Top