Tirvin,
I your case I think the hole point is to have clasified "types of faults". Then you could do analysis later on, besides the fact that you don't have to retype.
Not that the ValList should be in the same Workbook, but not necessarily in the same Worksheet as in the attachement.
Bookmarks