Forum Discussion
How to use today's date for invoicing, copied sheets
How to use today's date for an invoice template, and keep the date for each copie ( printed)
but when I duplicate this sheet in the workbook for each invoice as a reference, the date changes for those when I open my workbook
Facture 01 and Facture 02 : when I duplicate this sheet in the workbook for each invoice as a reference, the date changes for those when I open my workbook
Don't use a formula. You can enter the current date as a fixed value by pressing Ctrl+;
Alternatively, you could use VBA code to create a duplicate of the template sheet and enter the current date in the relevant cell of the copy.
1 Reply
Don't use a formula. You can enter the current date as a fixed value by pressing Ctrl+;
Alternatively, you could use VBA code to create a duplicate of the template sheet and enter the current date in the relevant cell of the copy.