Excel, Automatic posting of a Date Of Last Change.

[travler]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I would like to show the date of last change to a cell and have it displayed on the same worksheet. That date would be shown in a near-by cell. For example, a cost of item cell and a retail of item cell. If either cell was changed manually, then today's date would be recorded and retained until the next manual change in either cell. Have tried to use a conditional formatting solution and an "IF" formula but have not gotten it correctly.

 

[CyberTaz]

I don't see any feasible way to do so without VBA... And rather
sophisticated VBA at that. Neither the program nor the file track the date &
time of changes made to individual cells - or even that a change *has* been
made. Editing of a cell is an Event, not a Value, and there are no built-in
functions that monitor events.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[travler]

I don't see any feasible way to do so without VBA... And rather

 

[Bob Greenblatt]

several days and was feeling pretty dumb! I understand the situation now.

PMFJI, but you could share the workbook. Tools-Share Workbook. Even if
it is not actually shared (i.e. you are the only one using the workbook)
sharing will maintain a log of changes made.

 

[travler]

Will sharing keep each individual "date of change" cell date fixed until I make a change in the original "price" cell?

Or will it collect the overall date of any change done to the entire workbook? (Thank you for your suggestion)

 

[CyberTaz]

All changes - even multiple changes to the same cell - are individually
tracked. Although it may provide the solution to that one issue there are
also other considerations with Shared workbooks... For example, you cannot
create any charts or delete any sheets. Also, the changes are listed on a
separate History sheet which evaporates if you turn off the Shared property.

I'm certainly not dismissing Bob's suggestion, but I'd recommend that you
study up on Shared workbooks before going that route. See Excel Help on the
topic 'Share a workbook' as well as the related See Also links. More
detailed information can be found here:

http://office.microsoft.com/en-us/excel/CH062528461033.aspx

Although that link is to Excel 2003 Help virtually all of it pertains
equally to the Mac version.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[travler]

Thanks to all who have replied.
Just saw an update to the FileMaker database program that will allow my database to be imported into Excel spreadsheets with an automatic feature that may be a "work around" solution. If it works, I will update this message with the details.