How do I increment a number by1 each time I access it?

[Guest]

I use a shell proposal form in EXCEL want to be able to incrementally add 1
to the proposal number each time I access the shell.

 

[Guest]

There are 3 ways of doing this; using the registryto store a number - and a
macro to increment it and paste it to your proposal, using a macro to
increment a stored value by 1, and using a text file to store the number, and
a macro to increment and paste it to your proposal. Check out J E
McGimpsey's site to see how to use the registry. I think this method is
best, as nobody is going to accidentally wipe your number.

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

 

[Guest]

Thanks, that will work very well. Exactly whay I need.

 

[Guest]

Glad I could point you in the right direction! Thanks for the response.