+ Reply to Thread
Results 1 to 12 of 12

New to forum.. Want to do an advanced sorting option keeping row data together.

  1. #1
    Registered User
    Join Date
    09-14-2015
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    7

    New to forum.. Want to do an advanced sorting option keeping row data together.

    I'm new to the forum here, so if this is asked somewhere else, let me know. Thanks for any help!

    I am trying to figure out how to keep data on the same lines connected when a sort is done.

    This is complicated because the first half of sheet is CC'd from another sheet and second half of sheet is hard numbers and mathmatical formulas.

    For example here is sample of data on Sheet 2
    A1 = =Sheet1$A1, B1 = =Sheet1$B1, ..... AA1 = 1, BB1 = 2, CC = =(BB1-AA1)

    I want to be able to sort Sheet 1 and have the hard data on Sheet 2 (AA1, BB1, CC1 etc) to stick with the copied data on sheet 2 (A1, B1, C1 etc)

    I know I could a Vlookup, but that would get very large. Any other ideas?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    09-14-2015
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    7

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    What I want is to be able to sort Column A on Sheet 1 and have the data on Sheet 2 columns D,E, & F stay with its sorted copied data on Sheet 2 columns A, B, C.
    Attached Files Attached Files
    Last edited by Big_D_in_Va; 09-14-2015 at 11:06 AM.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    use sheet 2 column A, B and C also as imput sheet.

    Then you can use sheet 1 for presentaties (e.g. with a pivot table).

    I made the pivot table in this case on sheet 2.

  5. #5
    Registered User
    Join Date
    09-14-2015
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    7

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    I thought of that. But I would have the same sorting problem on sheet 1. I made an adjustment to my sample sheet and re-attached it so you can see it.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-14-2015
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    7

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    I cannot put everything on one sheet because some information needs to be compartmentalized.

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    I cannot put everything on one sheet because some information needs to be compartmentalized.

    yes you can, and it is a good idea using excel, to have all information (data) on 1 sheet.

    It makes it a lot easier to analyze.

  8. #8
    Registered User
    Join Date
    09-14-2015
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    7

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    Quote Originally Posted by oeldere View Post
    I cannot put everything on one sheet because some information needs to be compartmentalized.

    yes you can, and it is a good idea using excel, to have all information (data) on 1 sheet.

    It makes it a lot easier to analyze.
    Regardless, its not and we don't want it on the same sheet. Is there a way to tie the hard data to the copied data when its sorted?

  9. #9
    Registered User
    Join Date
    02-01-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    26

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    Does this help? See sheets 3 and 4. If it does I'll explain how I did it.

    Should mention you need to use the slicer boxes to filter.

    Simon3 - SampleBook.xlsx
    Last edited by Simon3; 09-14-2015 at 02:38 PM. Reason: additional info

  10. #10
    Registered User
    Join Date
    09-14-2015
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    7

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    I like that, but I am trying to avoid pivot tables as well. I'm trying to find a way to just use the two tables and just keep the hard data stuck to the copied cells.

  11. #11
    Registered User
    Join Date
    02-01-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    26

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    I combined all the data on sheet2 so I could split the data into the views you had set up. In your real workbook is there a place where all of this information is combined?

    If the data is a changing number of rows i don't think you will be able use just formulas because there isn't a formula to add or delete rows (as far as I know). You could look into powerpivot to create a relationship between the data but you will need a matching unique ID column in each table.

    Pivot tables are likely to be your best bet though since you can create relationships between the slicers and multiple tables, hold ctrl when clicking to select multiple filters, select the columns you want to display, etc.

  12. #12
    Registered User
    Join Date
    09-14-2015
    Location
    Virginia, USA
    MS-Off Ver
    2013
    Posts
    7

    Re: New to forum.. Want to do an advanced sorting option keeping row data together.

    Ok. I'll look at that closer.

    No, there is no place that all data is in the same place. In my real workbook, just as the sample, there is seperate data on both pages that ties to the copied data. But to compartmentalize some of the information and simplify the viewing, we want to keep the sheets seperate.

+ 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. Sorting while keeping data together
    By trmm in forum Excel General
    Replies: 1
    Last Post: 04-17-2015, 05:07 PM
  2. keeping the first empty row in a table after sorting the data
    By boboivan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2015, 03:16 PM
  3. Replies: 0
    Last Post: 01-25-2015, 05:41 AM
  4. [SOLVED] Sorting A Filter...Not keeping data the same
    By buddha in forum Excel General
    Replies: 2
    Last Post: 03-16-2013, 01:21 PM
  5. Sorting while keeping 2 columns of grouped data together
    By jenny8220 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2012, 05:53 PM
  6. Sorting & keeping data intact?
    By elfiky in forum Excel General
    Replies: 1
    Last Post: 03-24-2009, 04:38 PM
  7. [SOLVED] sorting (alphabetizing) while keeping data in tact.
    By 5string in forum Excel General
    Replies: 2
    Last Post: 10-10-2005, 12:05 AM

Tags for this Thread

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