Hi
Am a beginner for VBA & required your kind help me to get a better solution for below problem.
I have a shared excel file which is updating by multiple users with the material test results.
Attached sample file for your reference.
The raw number S is containing the test report number.
From Raw T to AL, the users needs to add the test results manually.
Raw AM is containing the overall the test result conclusion which I needs to update automatically as follows.
If T to AL all cell's are containing Approved & NA words, then the AM cell needs to update as Approved.
If T to AL any cells containing Y word, then the AM cell needs to update as Y.
If T to AL any cells containing Rejected word, then the AM cell needs to update as Rejected.
If T to AL any cells containing Rejected+Y, then the AM Cells needs to update as Rejected.
If T to AL all the cells containing NA, then the AM cell needs to update as NA.
The final note is some of the cell may have multiple words like below. For this case the word showing in the top needs to taken as final. [TABLE="border: 1, cellpadding: 1, width: 500"]
[tr][td]Approved
Rejected
Rejected
[/TABLE]
It is really helpful if some one can help me on this case. Appreciate your help here.