Hi,

I have a sheet where I want to provide guidance per cell on what to complete. The guidance will change so I don't want to use comments and have to change them every time. Is there a way of referencing a separate range in a sheet to display in a comment, either as a mouseover or click in cell?

I have already looked at the tool tip in Hyperlink and in Data Validation and some sort of VBA to link this up seems to be the route to go, but is beyond my skill level.

Any help much appreciated.

Robin