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,

See

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

In article ,
Connie wrote:

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,

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

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

In article ,
Connie wrote:

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,

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

In article ,
Connie wrote:

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 for your help.

"JE McGimpsey" wrote:

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

In article ,
Connie wrote:

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)?