macro

Giganews Newsgroups
Subject: macro
Posted by:  tfred
Date: Tue, 9 May 2006

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.

Replies