| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save date to workbook.
I have a workbook that I copy & paste into a pervious days folder. It has
22 tabs with multiple pages, when ever I go back and print a page that I need it has the current date, and not the date it is from. If I take the =today() formula off each page is there any other way to get the date it is from to print to the pages I want? -- Medzzz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save date to workbook.
TODAY() is a volatile function and will change every day.
Copy and paste special as a value. Or enter a date using CTRL + ;(semi-colon) which will not update tomorrow. Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 16:34:00 -0800, CevaClerkII <Joel Zurba/NA/TNT/TPG@Logistics wrote: I have a workbook that I copy & paste into a pervious days folder. It has 22 tabs with multiple pages, when ever I go back and print a page that I need it has the current date, and not the date it is from. If I take the =today() formula off each page is there any other way to get the date it is from to print to the pages I want? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save date to workbook.
That works, thanks.
-- Medzzz "Gord Dibben" wrote: TODAY() is a volatile function and will change every day. Copy and paste special as a value. Or enter a date using CTRL + ;(semi-colon) which will not update tomorrow. Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 16:34:00 -0800, CevaClerkII <Joel Zurba/NA/TNT/TPG@Logistics wrote: I have a workbook that I copy & paste into a pervious days folder. It has 22 tabs with multiple pages, when ever I go back and print a page that I need it has the current date, and not the date it is from. If I take the =today() formula off each page is there any other way to get the date it is from to print to the pages I want? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
| save workbook as current date using a macro | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| How do I save a workbook as a new workbook by using macros? | Excel Discussion (Misc queries) | |||
| Save Workbook as Current Date/Time | Excel Discussion (Misc queries) | |||
Linear Mode
