update timestamp if change_event for all column in row

Hi, all

I've found this super info by se1499
http://www.excelforum.com/excel-work...date-date.html
or
http://www.exceldigest.com/myblog/20...amp-in-a-cell/
that use this code to insert timestamp on the right of "A" cell.

Please Login or Register  to view this content.

It works only for any COLUMN A change, and use offset location for target cell (as I understand--)
How I can modify this code to make it work if specific list of cell in the single ROW has changed (e.g. B1..J1 ==> 10 cell row.
- and make timestamp also tobe in specific cell (let say in A1, or K1)

and to make it work for all rows. Can I do this this VB? or maybe use forms?

Appreciate your help, I'm trying to help one non-prof office to fill their food orders correctly, but I'm not that good in in VB, and they definetely can not go anywhere from Excell already provided to them by MS. THey just need to keep good log of all orders and their changes/cancellataions.


Tx to all
Dai

Thanks, Andrew.
Trying it right now.

Sorry if I mispresent my case..
I basically have order detail line in 10 columns for each row (A1,B1,....K1), let say 50 rows, one row for each order. THere is also header.
I put initial timestamp with iteration formula in A* column upon entering initial information for each row, but need to change this stamp or make another one on each row, if any column in detail row has been changed.


Best
Dai