Cell data

K

Kevin

I have data coming in to my spreadsheet via DDE link. I
want to use the Now() function to date stamp the data as
it changes but I want to keep a running list of the date
stamp in my spreadsheet so I can know how many times the
data changed and when by looking at the date stamps. How
can I accomplish this?
 
D

David McRitchie

Hi Kevin,
On rereading, your data is probably coming into one sheet,
I don't know if a change event will be picked up but you could
have whatever is entering the date. Is the date being added at the
end or simply replacing the existing cell. I suspect that I won't
be able to answer your question even if you give the missing
infomration.


------------------ if it were just if the workbook was updated ------
Don't know if this will serve your purpose or not

[a1] = "LastSaved"
[b1] = "Active when saved" (that is the sheetname)
[c1] = "active Cell"
[d1] = "UserName"

User controlled Save History as an alternative to Highlight Changes (#BeforeSave)
http://www.mvps.org/dmcritchie/excel/highlite#beforesave

Be aware that volatile functions such as NOW() will cause
the change bit to be set forcing a File Save.

Note on browsers:
FWIW, the Firefox browser is sensitive to case within the local link (anchor)
so you would have to use lower case as it stands now. for #beforesave
Internet Explorer and other browsers as I remember them couldn't care less.
If you want to read more see my
http://www.mvps.org/dmcritchie/firefox/firefox.htm#problems
I will probably change the visible wording. I can use a bookmarklet to
see what the ID (id=) really is.
 
Top