macro
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.
|