Automatically generate the next number when Worksheet on Open in Excel

Barb Henderson
Barb Henderson
40.5 هزار بار بازدید - 8 سال پیش - Increment the number on a
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. Check out my templates page for free and purchased templates www.easyexcelanswers.com/templates.html code Private Sub WorkbooK_Open() Range(“B8”).value = Range(“B8”).value+1 End sub For more help visit my website www.easyexcelanswers.com/ or email me at [email protected]. Contact me regarding customizing this template for your needs. Click for online Excel Consulting www.calendly.com/easyexcelanswers I am able to provide online help on your computer at a reasonable rate. www.amazon.com/shop/barbhenderson I use a Blue condenser Microphone to record my videos, here is the link amzn.to/37gyyGa Check out Crowdcast for creating your webinars app.linkmink.com/a/crowdcast/83 If you need to buy Office 2019 follow amzn.to/2VX5dv8 I use Tube Buddy to help promote my videos Check them out www.Tubebuddy.com/easyexcelanswers Follow me on Facebook www.facebook.com/easyexcel.answers TWEET THIS VIDEO    • Automatically generate the next numbe...   Follow me on twitter easyexcelanswers IG @barbhendersonconsulting You can help and generate a translation to you own language youtube.com/timedtext_cs_panel?c=UCFH2kZykqt-VX5W9… *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.
8 سال پیش در تاریخ 1395/10/09 منتشر شده است.
40,590 بـار بازدید شده
... بیشتر