source: http://articles.techrepublic.com.com/5100-10878_11-6025056.html
Suppose your Microsoft Excel workbook contains 10 worksheets, and you want to add a time and date stamp to each worksheet. You could manually enter a time and date formula into a cell in each worksheet, or you can create a named formula that can enter the current date and time without having to retype the formula.
To create the named formula, follow these steps:
- Press [Ctrl][F3].
- Enter DateStamp in the Names In Workbook text box.
- In the Refers To text box, enter the following formula:=TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM")
- Click the Add button and then click OK.
- Now you can add a time and date stamp to every worksheet in your workbook by typing =DateStamp in any cell.
more: http://www.ozgrid.com/forum/showthread.php?t=71988
and of course a simple VB macro:
