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.
Bookmarks