Here is how to do this. The first is by using a formula within VBA Visual Basic for Applications in order to generate invoice numbers for a single workbook. Select the first sheet.
The first is by using a formula within VBA Visual Basic for Applications in order to generate invoice numbers for a single workbook.
Select them and look out for a hair-cross in the bottom right corner. In the popped out New Formatting Rule dialog box please do the following operations. Type the starting value for the series. You can insert page numbers on multiple worksheets in your workbook by using the Page Setup dialog box.