Increment the number on a worksheet when open. Use a simple macro to increase the number with every open.
Invoice numbers, P.O. numbers will increase so that a new number is generated every time the workbook is open
code
Private Sub WorkbooK_Open()
Range(“B8”).value = Range(“B8”).value+1
End sub
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Brilliant
I appreciate this tutorial and video that you created for us. This is such valuable information. Thank you, Barb!
This explanation has been the most simplest and crystal clear to the point. Thank you so much.
Omg I have been looking for this for SOOOOOOOO LONG!!!!!! Thank you!!!!!!
I'm using this to generate invoice numbers and I can't edit an invoice without it changing the invoice number once I open the worksheet. Any suggestions on how I can get around this?
Thank you
Thank you, that is perfect!!! Great help to auto number a workbook that is used by mutiple people and ensure every saved item has a unique number.
it generates automatically every time open and how if it is opened just to view it skip the no? our invoice no sequence change?
its not working for me +
How do I access or view previous "work order"
What if I want to increment when I create a new sheet? Can you please help with the code
Does this work on the 2020 version?
Quick and easy very good video
I’m struggling with this one I’m using an excel invoice template and followed this as closely as possible but it keeps coming up as a bug in the code
WHAT IS THE CODE IF I WANT TO START FROM SPECIFIC# THEN +1.
Hi,
this video is great ao thank you but i am having trouble as I am using an alphanumberic number "SS15001" and would like it to go to "SS15002".
How do I do this please?
Thank you so much. The best instruction on this subject that I've seen. Appreciate it!!