Hello,
There is a feature in Power BI that I wanted to see if it exists in Excel.
There are a lists of assignments that when the user hovers over the number, the description of the assignment appears. It may be one or two sentences.
I have been researching to see if there is an equivalent like that in Excel; the closest I have come across is a comment or a note. The user should ideally click the comment and see the description.
The only way I could think to achieve this would be to add a comment in every cell with the specific description.
My question is if there is a VBA function that can create a comment in the cell or a note that takes the description from one sheet and is able to match it in the cells in other worksheet where that assignment number appears?
Even though it would be time-consuming, the most direct route would be to create the comment and copy and paste into the cell. Thank you.
There is a feature in Power BI that I wanted to see if it exists in Excel.
There are a lists of assignments that when the user hovers over the number, the description of the assignment appears. It may be one or two sentences.
I have been researching to see if there is an equivalent like that in Excel; the closest I have come across is a comment or a note. The user should ideally click the comment and see the description.
The only way I could think to achieve this would be to add a comment in every cell with the specific description.
My question is if there is a VBA function that can create a comment in the cell or a note that takes the description from one sheet and is able to match it in the cells in other worksheet where that assignment number appears?
Even though it would be time-consuming, the most direct route would be to create the comment and copy and paste into the cell. Thank you.
