Teaam,
Can anyone help me with the below requirement please.
In Summary sheet I need to sort NAME OF THE TABLES WITH FAILED TEST CASE (Column E) and
Analysis Rows Based on Priority of the Tables in Result Sheet. Please suggest me how to proceed.
NAME OF THE TABLES WITH FAILED TEST CASE - Please refer to 'Result Sheet' Column G and H for Priority of the Tables. Already I have applied to show only Failed Table Names in Summary sheet, but Failed Table Names need to be
sorted based on Priority of the Tables based on Column G & F in Result Sheet.
Analysis - Already I applied the logic to shown only the Failed Test cases which you can find in 'Fail Details' Sheet, but the test cases - Table Names need to sorted based on Column G & F in Result Sheet. This is in Format Table Name /
Test Cases Name / RCA. What ever we have in this sheet we are showing in Summary Sheet in Analysis Rows, so we need to sort this sheet based on Column A (Table Name) and that to based on Priority of Column G and H in
Results Sheet.
So, when I click on Click to Update in Developer sheet then NAME OF THE TABLES WITH FAILED TEST CASE and
Analysis Rows should be sorted based on Priority in Result Sheet for Table Names.
Please find the attachment file in the below link.
https://onedrive.live.com/redir?resid=AC356A87FAADE1FC%21120
- Edited by Kiran Kandavalli Tuesday, February 17, 2015 2:41 AM