Hello Folks. I need one help. Below is my problem explanation along with Expected Solution. Please review the same and help me to provide a suitable resolution.
📌 Objective:
We are maintaining a Risk-Issue table in Confluence, where data is copied from Excel. This table is used as input for the Pivot Table macro to generate a Risk Owner Matrix. One of the key columns in this table is "Assignee", which captures the name of the Risk/Issue owner.
🎯 Challenge:
Currently, the "Assignee" field is a free-text input. This leads to several issues:
- Inconsistent naming: For example, my name "Md Ahsan Raza" might be entered as "Ahsan", "Raza", or "Ahsan Raza".
- Spelling errors: Mistakes like "Ahsab" can occur.
- Data fragmentation: These inconsistencies distort the accuracy of the Risk Owner Matrix, especially when the dataset grows to hundreds or thousands of records.
✅ Expected Solution:
To ensure data consistency and reduce manual errors, I am looking for a way to implement an auto-suggestion or dropdown feature in the "Assignee" column. This would:
- Provide a predefined list of valid names.
- Allow users to select from suggestions as they type.
- Minimize the risk of typos or inconsistent entries.
- Ensure the Pivot Table output remains accurate and reliable.
