Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I set an excel spreadsheet to automatically insert a current date and
save that date when the workbook is closed. The next time the workbook is open on a different day it inserts the current date two rows from the last row that contains data. For example: Date: 05/09/06 €“ Automatic insert current date when Workbook is open Tom Hanks 8hr $12.00 Hr. Paul Thomas 10hr $11.00 Hr. Close workbook€¦.date is saved automatically Next day€¦.open workbook and Excel automatically inserts the current date two rolls down from last data entered. For example: Date: 05/09/06 Tom Hanks 8hr $12.00 Hr. Paul Thomas 10hr $11.00 Hr. Date: 05/10/06 Tom Hanks 7hr $12.00 Hr. Paul Thomas 8hr $11.00 Hr. Sue Smith 8hr $12.00 Hr. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |