Track Failed Test Cases

[supputuri]

If I get your question correctly, maintain a sheet with all the Testcases/scripts and update the status of the testcase in the sheet at the end of each execution. So that you will have the latest status of your test in one place (I would keep a flag to update the status in Excel so that if i am developing a test it doesn't update the status by switching off the flag).

Let me know if you need any help on this.