I know you can do this with a worksheet function
http://groups.google.com.sg/group/mi...e=source&hl=en
but I'm using it to track when data was input by users and its difficult to tell them to click the "enable macros" button every time when I can hardley explain to them how to use excel to input data. So, to make this easier for everyone but me isn't there some way I can just do
"if a1's data has changed then put the date in b1" Thanks in advance for any responses.