Hi, everyone.
I am a new in IT area. There is a problem to me. If there's possible to detect a changing date and time in the same row?
For example:
Original Copy:
------------------------------------------------------------------
| A | B |
------------------------------------------------------------------
| | |
------------------------------------------------------------------
Once user has entered the data to the worksheet, it will auto detect the row changed time. Such as the following example:
After modified: When i enter the B column as value 123, and the same row, column A will auto detect changed time for that row. And show out the modified date time to me, such as modified at 11:00:00 am 12th May 2010.
------------------------------------------------------------------
| A | B |
------------------------------------------------------------------
20100512110000| 123 |
------------------------------------------------------------------
Is it need to write in macro or any excel formula can fulfill my requirement?
Thanks for your kindly concern and help. Thanks in advance.
Best Regards
Cheeloon
Bookmarks