+ Reply to Thread
Results 1 to 2 of 2

Need to Sort Columns in Summary Sheet Based on Priority Columns

  1. #1
    Forum Contributor
    Join Date
    12-17-2014
    Location
    Charlotte
    MS-Off Ver
    2013
    Posts
    137

    Need to Sort Columns in Summary Sheet Based on Priority Columns

    Team,

    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 attached file for your reference.

    Thanks!
    Kiran
    Attached Files Attached Files
    Last edited by Kandavalli.Kiran; 02-17-2015 at 08:37 AM.

  2. #2
    Forum Contributor
    Join Date
    12-17-2014
    Location
    Charlotte
    MS-Off Ver
    2013
    Posts
    137

    Re: Need to Sort Columns in Summary Sheet Based on Priority Columns

    Jindon & Team,

    Can anyone please help me on this.

    Thanks!
    Kiran
    Last edited by Kandavalli.Kiran; 02-17-2015 at 08:37 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compare Sheets and sort columns based on sheet 3
    By anandrajagopal in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-12-2015, 08:41 AM
  2. To sort 3 columns with a priority list
    By Raury in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2014, 10:52 AM
  3. sort columns and partially linked columns on another sheet
    By Zooka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2013, 06:16 PM
  4. Sort multiple sheets based on 2 columns in 1 sheet
    By grahamc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2012, 04:39 PM
  5. Ability to sort by Sheet, Columns, Within those columns, and Operations on Info
    By TopC1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-22-2010, 10:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1