+ Reply to Thread
Results 1 to 2 of 2

Moving rows adjacent to pivot table rows

  1. #1
    Registered User
    Join Date
    03-15-2019
    Location
    Montreal
    MS-Off Ver
    2016
    Posts
    1

    Moving rows adjacent to pivot table rows

    I have a slight problem with the way the data in a pivot table is presented when there are adjacent rows next to said pivot table.
    I have a table that contains a list of "Names" and "Types" as columns. I'm using a pivot table on a separate worksheet in order to show all of the "Names" of a certain type. Basically, there are 3 different types, so I have 3 separate worksheets with a pivot table in each one that shows all of the names in the original table of the specified type. The reason I chose to use a pivot table is because I want to avoid filtering the table by type and copy/pasting all of the names of each type to a different sheet.
    The problem that I'm having is that I'd like to use these separate lists of names as completely new tables, basically. For example, I'd like to have a column detailing when an associated name was sent a certain document. Is there a way to have this column, which is completely unrelated to the original table used to generate the pivot tables, move accordingly with the pivot table if ever the order of entries are changed when refreshing said table? Basically like creating a link between the elements of the pivot table and a column adjacent to the table, but not included in the table. That way, if ever a name from the original table is changed, I wouldn't have to worry about the date column next to the pivot table (which might change after a refresh) being out of order.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,670

    Re: Moving rows adjacent to pivot table rows

    Things would go a lot better with a sample workbook, but it sounds like you can overlay the pivot table results and the adjacent cells with a named dynamic range and use that as the source for a new pivot table.

    If you want to give it a shot on your own, here is some information on named dynamic ranges: http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges.

    If you need additional help then ...
    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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