Forum Discussion
AnnieMaisonneuve
Jan 09, 2025Copper Contributor
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.
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.