Hi,

I am using excel 97 and need some help to achive the following.

When a cell value is changed I want a 'Y' to be entered in a given cell further across on that row. I have mutiple rows but the 'Y' that is entered must be on the same row as where the cell value has changed.

If any one can help I will be very happy