• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add Pass/Fail values from summary data to table

I have manually gathered data. I am looking for vba which will look row and column and filll the cell with "Fail" word. When this will be accomplished, I can fill blank cells with "Pass" value easily. But want to add "Fail" first in table.
Any help will be appreciated.
 

Attachments

If your "Failing Values" will be like as below then it will ease else seems :p

HTML:
Failing Values
-20, -21, -22, -23, 20
  -22, -23, 22
-
-22, -23, 22, 23
-20, -22, 20, 22
-22, -23, -24
-
-20, -22, 20, 22
-21, -24, 21, 24
-22, 22
-22, -23, 22, 23
-23, 23
 
Back
Top