wborlando
New member
- Joined
- Jun 8, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi,
I'm working on a spreadsheet with a formula that returns a "Yes" from a list of employees of those employees who received letters. The list is on a different sheet within the workbook, the list also includes information on the description of the letter. I'm trying to create a pop-up comment on the spreadsheet with the formula that has the "Yes" for the pop-up to show the description of the letter for that specific employee. In other words, if the cell has a yes, I want to show the description of the letter as a pop-up comment for that specific person. However, it may be from two different cells within the sheet for that same employee.
I'm not sure if that is something I could add to the formula I already have, or if that's something I will need to do on VBA and if so, I have no clue how to start it.
Thank you.
I'm working on a spreadsheet with a formula that returns a "Yes" from a list of employees of those employees who received letters. The list is on a different sheet within the workbook, the list also includes information on the description of the letter. I'm trying to create a pop-up comment on the spreadsheet with the formula that has the "Yes" for the pop-up to show the description of the letter for that specific employee. In other words, if the cell has a yes, I want to show the description of the letter as a pop-up comment for that specific person. However, it may be from two different cells within the sheet for that same employee.
I'm not sure if that is something I could add to the formula I already have, or if that's something I will need to do on VBA and if so, I have no clue how to start it.
Thank you.