Replacing Text in a cell based on a the text of a new cell.

[david gabra]

Hi
I have spent a lot of time building a testing dashbaord, but it has one fatal flaw - the results are not accurate.
The reason is due to the fact that the cells it is reading is not the most upto answer.
Let me explain.

Example Row 15 on the attached excel.

I use column L for stating if the test passed. E.g. Fail.
I use column N for stating the IMPACT of a failure. Eg. Impact is high.

The user can then retest.
If the bug was fixed, then the user can UPDATE status to 'PASS' (column V). The user can also update the IMPACT to another level (column w).

Condition:
I need for the my stats to take the data from the updated columns (V and W) when both conditions below hold true.
(1) there was a failure, as noted in column (L)
(2) if retesting was perfomed (If coumn S = "Yes")

Basically, columns (V and W) will replace column L & N

Before



After: - we should see this - this is what we to acheive - for the impact and the changing the fialed to passed.




.
thanks

Pleaase make solution as simple as possible.
Preferably no macros, but if needd and not choice, then we can use.

David.

 

[david gabra]

Pleaase make solution as simple as possible.
Preferably no macros, but if needd and not choice, then we can use.