Hello Everyone,
I work as part of a hotel & am trying to work on a report.
Please can someone help me find an answer.
I have a table with Column C where employees assigned this task put in comments on a daily basis.
I review this report & make changes if any before the report is shared to mt Boss.
The comments are very important for decisions to be made.
Is there a Macro that can help me on this ? Can i do the changes to the comment when I double click ?
<tbody>
</tbody>
Please Guide me find an answer,
Thanks in Advance.
Steeve.
I work as part of a hotel & am trying to work on a report.
Please can someone help me find an answer.
I have a table with Column C where employees assigned this task put in comments on a daily basis.
I review this report & make changes if any before the report is shared to mt Boss.
The comments are very important for decisions to be made.
Is there a Macro that can help me on this ? Can i do the changes to the comment when I double click ?
SHEET 1 | Coulmn A | Column B | Column C | ColumnD |
Row 1 | Unit | Trend | Comments | |
Row 2 | Reception | Upwards | 10 Regular Customers acknowledged improvement in last 9 months | Col C is populated from another Sheet. SHEET2. When I double click Cell C2, it should allow me to edit the comment & save the changes in Cell C2 only. |
Row 3 | Laundry | No Change | No Comments | |
Row 4 | Security | Downwards | 2 cases booked on 08Apr, 2018 | |
Row 5 | etc.. |
<tbody>
</tbody>
Please Guide me find an answer,
Thanks in Advance.
Steeve.