Results 1 to 12 of 12

Assistance needed with Dynamic Action List attached to an Excel Pivot Table.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-05-2021
    Location
    Netherlands
    MS-Off Ver
    Microsoft Excel 365 (version 2022, Build 14931.20764)
    Posts
    189

    Assistance needed with Dynamic Action List attached to an Excel Pivot Table.

    Dear Excel specialists,

    I have a quick question regarding my Excel workbook, which consists of two tabs:
    1. Pivot Tab
    2. Data Tab

    The Data Tab contains a wide variety of content that changes weekly. I utilize the Pivot Table to filter applications that are associated with specific security risk issues (e.g., High, Medium, Low risk, et cetera)).
    Recently, I've received requests to incorporate an action list for each application, detailing how to address the identified security risks. However, since the Data Tab is dynamic, the items in the Pivot Table—including application names—also change.

    My question is: How can I effectively attach/link or associate the action list items with the dynamically changing items in the Pivot Table?
    I don't want to add an extra column in the Data tab, because this is already an extensive list (also not usable/readable for management).

    Is there an easy solution available that is also good to maintain?

    Best regards,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Needed a unique drop down list from a duplicated table without pivot table
    By Noman050 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-04-2022, 12:58 PM
  2. Replies: 2
    Last Post: 06-16-2016, 10:59 AM
  3. Dynamic Data Validation List Using Pivot Table
    By seethesun in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-05-2016, 11:02 AM
  4. Filtering pivot table on dynamic list
    By Nmarkit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2013, 11:11 AM
  5. Pivot Table Assistance Needed
    By RaydenEG in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-19-2009, 01:50 PM
  6. Dynamic List info, do I need a pivot table?
    By kevinhes in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-09-2007, 05:40 PM
  7. [SOLVED] Pivot Table Assistance Needed
    By Barb R. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-11-2005, 10:06 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