Hi all,
I have a drop down list of my employees in A1. I would like to use B1 as a "Comments Box".
In C1 I would like to read the comments that I wrote for each employee.
Therefore I need a VBA code that stores whatever I type in B1 so that I can retrieve it in C1 when I choose any employee from the list.
I'm not sure if I'm asking for too much but I hope I can have some support.
I have a drop down list of my employees in A1. I would like to use B1 as a "Comments Box".
In C1 I would like to read the comments that I wrote for each employee.
Therefore I need a VBA code that stores whatever I type in B1 so that I can retrieve it in C1 when I choose any employee from the list.
I'm not sure if I'm asking for too much but I hope I can have some support.