Hi,
Fairly seasoned user of Excel using MS 365 for Business. Since this is a specific Excel question, I've posted here instead of the O365 thread.
I have a named table range [Countries] in my worksheet Reference! with some cells in the range that have notes.
Is there a way when referencing that range in a lists Data Validation that the Notes can come over too?
I'm guessing that the Notes are attached to the cell and not the data. For example, I can add a note to the cell and delete the data, and the note persists.
I know that the note can be referenced from the XML, but not how to bring it to the cell that has a data validation.
I can write VB if that is the only solution. But wouldn't it be cool if Excel offered this capability out of the box!?
Thanks,
Narlo
Bookmarks