Change cell value to next in series upon opening worksheet?

G

Guest

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,
 
G

Guest

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...
 
G

Guest

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 Cell Value on Worksheet Change 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Go to worksheet upon opening 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to search multiple worksheets in a workbook for information? 2
How to refer cell E53 from the previous (=next left) worksheet? 2
Report design to show one line per a number in a series 1
Skip to next input cell on protected worksheet 6

Top