Sat 18 Mar 2017

Downloads 13 - Template 11 - Invoice Template

By |Saturday, March 18th, 2017|Categories: Downloads|Tags: , , , , , , , , , , |0 Comments

The invoice template is specifically designed for Service Invoices in India but this can be used anywhere in the world with little customization.

There are two templates, one which populates the amount in words in Rupees and Paise and one which populates in Dollar and Cents. If you need to change these currencies, you can write to me to change them.

(more…)

Sat 20 Aug 2016

Tips and Tricks 143 - Increment a Number when Workbook is Opened (Invoice or PO Number)

By |Saturday, August 20th, 2016|Categories: Tips and Tricks, VBA|Tags: , , , , , , , |0 Comments

1. Make a backup of your workbook.
2. Open your workbook and ALT+F11
3. Locate your Workbook name in Project Explorer Window
4. Double Click on "This Workbook"
5. Copy paste the Macro code given - Replace Sheet1 and B1 as per your need
6. Save your file as .xlsm if you intend to reuse Macro again.

< A workbook illustrating this can be downloaded from Invoice Number Generator >

'**** Macro Starts

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("B1") = Worksheets("Sheet1").Range("B1") + 1
End Sub