+ Reply to Thread
Results 1 to 1 of 1

Sorting between tabs & retaining row integrity.

  1. #1
    Registered User
    Join Date
    Austin TX
    MS-Off Ver

    Sorting between tabs & retaining row integrity.

    I have a complicated question but I hope you have a 'simple' answer.

    I have a workbook.
    It has 3 tabs but there are 2 giving me problems.
    1st tab = ALL ISSUES and on it there are columns A - Q
    In the 1st tab, it lists defect information including defect number, category, issue state, priority, and various other data points.
    The 1st tab is the 'heart' of the spreadsheet with multiple teams reviewing, sorting, inputting, changing and adding new data.
    The data on the 1st tab is subject to filters, logic & manipulation. On the 1st tab, there is 1 column connected to the 3rd tab; PRIORITY is 'copied' from the 'SCORE' tab after the team scores the defect.

    The 2nd tab is used as a summary tab and it causes me no problems.

    3rd tab = SCORE and on it there are columns A - P.

    On the 3rd tab, there are columns connected to the 1st tab; specifically the ID #, the issue summary, the category.

    My problem is the fact that when I SORT the data on the 1st tab, the data on the 3rd tab does NOT retain row integrity. I am using a few functions on all of the tabs but specifically on the 3rd tab, I have a IF statement. In addition, I am looking VLOOKUP between the 2 tabs; tab 1 and tab 3.

    When the users score the defects on the third tab, it is used to prioritize the work from the 1st tab. I need the data on the 3rd tab to retain its row integrity. Without it, the scoring effort becomes wasted and the team has to do it again.

    A sample of the workbook will be attached for your review. I want to submit the ticket and then I will add the workbook. I am unable to do it at this time and don't want to lose the thread.

    If I need to include the actual IF and VLOOKUP statements here, I can also do so.
    Last edited by vivalin10; 07-30-2015 at 10:31 AM. Reason: adding attachment.

+ 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. Pulling cells through to different tabs and retaining their web links
    By mparker123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2014, 04:58 AM
  2. Sorting TABS
    By ajm5807 in forum Excel General
    Replies: 11
    Last Post: 10-14-2014, 07:49 PM
  3. [SOLVED] Retaining forumals when moving tabs to a new document
    By Jeremy112 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-10-2012, 11:39 AM
  4. Retaining cell borders when sorting
    By sgreger1 in forum Excel General
    Replies: 1
    Last Post: 10-26-2011, 07:20 AM
  5. Dynamic sorting - keepting data integrity problem
    By widodud in forum Excel General
    Replies: 3
    Last Post: 08-20-2009, 09:43 PM
  6. Sorting 2 similar columns and retaining row details
    By darksoth in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2008, 09:45 PM
  7. Retaining Cell Data after Sorting
    By pharri11 in forum Excel General
    Replies: 2
    Last Post: 12-19-2007, 02:00 AM


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