When you history a macro, Excel simply follows no matter what you are doing from the workbook and develop a code for it. Now you could run this code and Excel will routinely observe every one of the steps you showed it. You can use this Invoice Generator template to quickly generate and save Bill as PDF (or Excel data files). All you'll want to do