Thread: macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tfred
 
Posts: n/a
Default 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.