update timestamp if change_event for all column in row

[dainova]

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.

Private Sub Worksheet_Change(ByVal Target As Range)
	Col = Left(Target.Address, 2)
	if Col = "$A" Then Target.Offset(0, 1) = Now
End Sub

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