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 17th, 2015 2:41am

Hi Kiran,

You can also consider Power Query to reach your goal.

It will allow you to merge all your columns into a single table and apply sort by the logic that you need, without using Macros. Then every refresh will sort the table as needed.

Microsoft Power Query is an Add-in for Excel. It is available for free for Office 365 Professional Plus, Excel 2013 and 2010 Professional Plus or Standalone.

You can download it here.

Free Windows Admin Tool Kit Click here and download it now
March 12th, 2015 6:40am

Hi Kiran,

agree to Gils proposal.If you need to collect lots of data and create different reports on it - Power Query is also my favourite - and easier to learn than usually expected.

Excels sorting works fine within a table or range, but requires macros if you want to span different tables.

However, if you want to stick to Standard Excel, how about using a hidden VLOOKUP-column where you grab the values to sort by? 

March 16th, 2015 3:47pm

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

Other recent topics Other recent topics