Dashboard Commentary Field

[Corleone]

Hi
I have set up a dashboard (see eg below) where the user can click on the project name using a drop down and it pulls out the relevant dates from the source data using XLookups
My query is, is there a way of setting up the SAD Milestones comments box at the bottom so that the user can type their comments directly in there.?
Currently the only way this will work is for the user to put the comments in a separate tab and i use an xlookup to pull the comments through - but i would like to have it set up so the user can put the comments directly in the box and then when a different Project name is selected the comments that were typed in the box (of there were any) automatically appear.

 

[MountainFog]

Are you open to VBA? If not, no.

 

[Corleone]

Are you open to VBA? If not, no.

Yes - - The cell for the comments box is A9 (Thanks)

 

[MountainFog]

Can you upload a copy of your file with dummy data? dropbox link prefered