flag any change made in row

[John Keith]

I want to enter today's date in column A anytime that a change is made
in the row, e.g. enter today's date in A1 if any cell from B1 to ZZ1
is changed. Are there any fucntions that can be invoked to do this or
does it require some VBA code?

Suggestions would be most appreciated.



John Keith
(e-mail address removed)

 

[Dave Peterson]

You could use an event macro.

See JE McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html

 

[John Keith]

You could use an event macro.

See JE McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html

Dave,

Thank you for the very quick response and the informative link.

The event macro is interesting but I'm not ready to tackle trying to
use VBA for doing this.

The circular reference and worksheet functions on the link above have
given me some ideas how that might work for me but that option
requires a change also. That example works only for entering new
content into a blank cell. I need to enter today's date every time the
contents of a cell changes.


John Keith
(e-mail address removed)

 

[Dave Peterson]

You may find that setting calculation to manual pays too high a price--and the
the code that JE supplies is easier to implement.

If you do try the code and have trouble, post back with what you did and your
follow-up questions.

 

[John Keith]

Dave,

Thank you again for your reply.

You may find that setting calculation to manual pays too high a price--and the
the code that JE supplies is easier to implement.

The spreadsheet is not being used for calculation (it is an
information data base where columns and rows are useful for relational
purposes) so the calculation change is not a big issue.

Having said all of that I've thought that maybe the long term solution
for what I'm tracking might be to use Access but that's off in the
future so for now I'm trying to make Excel work.

If you do try the code and have trouble, post back with what you did and your
follow-up questions.

Thank you for the offer, but I'm so unknowledgeable about macro code
that I don't even know where to start. It's been a long time desire to
learn how to do this but I'm not in an environment that is supportive
for me to try and attempt that right now. I truly appreciate your
willingness to respond to follow-up questions but for now I'll pass.



John Keith
(e-mail address removed)