Learn Excel 2010 - "Next Invoice Number": Podcast #1505

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to 'Macro Enable' our Workbook and then create a short VBA Code routine to automatically generate Invoice Numbers with the press of a mouse button.
Note: A similar discussion happened in episodes 742-745. You might want to review those videos as well, as they go the extra step of creating an add-in.
PLEASE - if you need to save as PDF or if you alphanumeric invoice numbers, read through the FAQ at https://www.mrexcel.com/news/next-invoice-number/. Your question has already been answered many times in the comments below.

New on October 16 2013 - a follow-up video, episode 1808 shows how to add an automatic Invoice Register to this code. See http://youtu.be/ili5hud7yR8

Table of Contents
(0:00) Introduction & Welcome to Excel Next Invoice Number
(0:15) Downloading an Invoice from Office Online
(0:40) Remember where the invoice number cell is
(1:00) Save as Macro-Enabled Workbook
(1:25) Switch to the VBA Editor with Alt+F11
(1:45) NextInvoice Macro
(2:20) Clearing out old data in invoice
(2:45) Using .ClearContents
(2:57) Running the macro from a Shape
(3:34) Running the code the first time
(3:42) Save each invoice before clearing
(5:05) Make sure to save before filling in invoice
(5:44) Wrap Up

This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Видео Learn Excel 2010 - "Next Invoice Number": Podcast #1505 канала MrExcel.com