return column of change

[danovkos]

hi all,
pls. i have table (2000r and 20 col). It contains data (type of W, R and blank).
This table represent status of names and in column are months. I want to know, when changed status of name to actual status and result add to column B.

I need into column B for each row in table return name from 1st row, where change character from W to R or from R to W or from blank to W or R or oposit. I want to return name (header jan-okt) of column where change character to other one.
The column C is basic value (actual status).
How can do this?

Here is sample.
Thank you for your help.

[stanleydgrom]

danovkos,

See the attached workbook "Worksheet_Change Event - return column of change - danovkos - SDG09.xls".

Make changes to the cells in range C3:T2000. This range will only accept "w", "W", "r", or "R" entries into range C3:T2000.


Have a great day,
Stan

[danovkos]

i will try it and tomarow i write if its works for me.
thx

[danovkos]

I tried it.
But it return to column B last changed value.
Do you think that it is possible to do this with some formula?
thx