Dynamic Notes?

[PrettyGood_Not Great]

Is is possible to have a note, dynamically populated? Could one perform a lookup with a cell reference and the result appear in a note?

 

[PrettyGood_Not Great]

Let me put it this way, if you want to update a Note automatically, VBA is the only way

I with you there, my VBA skills are lacking, so my questions are just to get help on that front. Do I need to modify the VBA code to accomodate the second mini sheet I posted?

 

[Jeffrey Mahoney]

I'm not understanding your request. The last mini sheet you posted gave me no cells that you wanted to change the Note. Do you need a dynamic note now? What would you put in it? What would you update it from?

The macro I provided allows you to change the named range at the top, so you could add a range or multiples cells in the named range. It still could work the same way because the Note contains a =cell address to provide the Note contents.

It sounds like you're unwilling to try the code, so maybe this is too far beyond your needs. I am not at all criticizing you, it's just that this would have to be altered for your changing needs so it may become too much to manage.

Jeff