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