PDA

View Full Version : return column of change



danovkos
11-10-2009, 06:44 AM
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
11-10-2009, 08:25 AM
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
11-10-2009, 08:31 AM
i will try it and tomarow i write if its works for me.
thx

danovkos
11-11-2009, 12:13 AM
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