Need to Sort the Columns Based on Priority Columns in Another Sheet

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


Thanks!
Kiran


February 16th, 2015 9:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics