excel - add current date to cell when anything is modified

[onetoo]

Hi Everyone-
Thanks in advance for reading this question-

I need to have a cell (at the end of a row) automatically insert the current date when anything in that particular row is modified.
It's a shared project status report and we want to be able to see what was changed when any other user looks at the worksheet.

This will be a worksheet on a shared folder with sharing on-

Any tips?

Also is there any way to have it automatically enter who changed that row?

[theDude]

This is from Excel HELP:

Turn on the change history for a workbook
When you keep the change history for a workbook, Microsoft Excel also turns on workbook sharing. Some Microsoft Excel commands and operations are not available in a shared workbook.

On the Tools menu, click Share Workbook, and then click the Editing tab.


Select the Allow changes by more than one user at the same time check box.


Click the Advanced tab.


Under Track changes, click Keep change history for, and then type the number of days you want to maintain the change history in the Days box.
Be sure to enter a large-enough number of days because Excel incrementally erases the change history permanently after the number of days elapses.

Click OK, and when prompted to save the file, click OK.

Notes

The change history includes information about how users resolved conflicting changes to the workbook, including the data from changes that were discarded.


Each time you close the workbook, Microsoft Excel erases any part of the stored change history that is older than the number of days you specified. The actual changes are retained.


Microsoft Excel does not turn on change highlighting when you turn on the change history.

--------------------------------------------------------------------------------------------------------

View workbook changes for a particular date, user, or range of cells
On the Tools menu, point to Track Changes, and then click Highlight Changes.

Make sure the Track changes while editing check box is selected. This check box turns on workbook sharing and the change history.
If the Track changes while editing check box is not selected, Microsoft Excel has not saved any changes for you to view.

Under Highlight which changes, select the types of changes you want to see. You must select at least one of the following:
To view changes entered since a specific date, select the When check box, click Since date in the When box, and then type a date in the When box. To view changes from the time when the change history was turned on, click All in the When box.

To view changes made by a specific user, select the Who check box, and then click a user in the Who box.

To view all changes to a specific range of cells, select the Where check box, and then enter a range reference in the Where box, or select a range on the worksheet. To view changes to the entire workbook, clear the Where check box.

To view the changes highlighted on the worksheet and display details when you rest the pointer over a changed cell, select the Highlight changes on screen check box.
To view the details about changes on a separate History worksheet, select the List changes on a new sheet check box.

Click OK, and if prompted, save the workbook.


Notes

The List changes on a new sheet check box becomes available only after the workbook has been saved with the Track changes while editing check box selected.


If you save the workbook, Excel removes the History worksheet. To view the History worksheet after you save, you must repeat steps 1 through 5.

Hope this helps,
theDude