Hi, I am using excel 2010. I am using a sheet with the =Today() function which is fine when I initially open the sheet. Is there a way that when I re-open the sheet (next day or next week, next month) that I can stop the date from updating to the current date?
Also I have a workbook with six sheets. One of the sheets is an invoice form and once the invoice is raised I would like to save this invoice sheet only to another workbook. Is this possible in excel?
Thanks for your help
Also I have a workbook with six sheets. One of the sheets is an invoice form and once the invoice is raised I would like to save this invoice sheet only to another workbook. Is this possible in excel?
Thanks for your help