I have a spreadsheet that the company uses, that when opened, inserts today's date in a cell. When we are done filling out the form and save it to our server, I reopen the file and run a macro that creates the order form and sends the pertinent information to our shipping and receiving department, including the date of the order.

The problem is that when I reopen the file to create the order form, it updates today's date, instead of leaving the original order date.

Is there a way to copy the original date to the order form (same workbook) so that it doesn't update?

Currently, I use a macro that creates the order form automatically behind the scenes every time the user collapses the sheet to clean up any blank rows for the customer to approve. Maybe the solution is to have another button that says "Finalize Order" or something and then puts a non-volatile date on the order form.