rosetc16
New member
- Joined
- Apr 22, 2017
- Messages
- 43
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
So I have multiple tabs (see attached) and I'm hoping I can transfer my comment into my pivot table along with the data that is in the cell. I have a validation tab that has the cells with the comment. I want to transfer that cell and the comment into the data source tab (currently using a vlookup to pull the data, but clearly doesn't pull the comment as well), which will then go into a pivot table. If I have to take the comment and make that into a separate column (not ideal), I can do that, but I'd like to make it so that when you double click the name, it will show you all the details.
Currently, I don't really know how to do any of this, so if you could give me some help, that would be great. Thanks! See attached for the example.
View attachment Example.xlsx
Currently, I don't really know how to do any of this, so if you could give me some help, that would be great. Thanks! See attached for the example.
View attachment Example.xlsx
Last edited by a moderator: