Hello,
I am trying to Create a logging sheet with the following columns. The sheet contains items which need to be tracked and each one has a 'log' against it which logs all previous actions. There is a meeting each week and before that meeting there is a manual task where We have to append the contents of 'Previous actions (J)' into 'Log(I)' and then replace 'Previous actions (J) with 'Next Actions' (K). This is a rather tedious and repetitive task but I am struggling with automating it in excel.
<tbody>
</tbody>
In the example above, I would need first "04/06 - OLD UPDATE" to go into the bottom of the "LOG" column as a new line under 09/04 ****, then I would need
"14/06 - NEW UPDATE" to replace the contents of the "PREVIOUS ACTIONS " column.
I'm totally stuck and don't even know where to begin. If anyone would be able to help at all, I would be extremely grateful.
Thank you very much in advance.
Regards
AnnPan
I am trying to Create a logging sheet with the following columns. The sheet contains items which need to be tracked and each one has a 'log' against it which logs all previous actions. There is a meeting each week and before that meeting there is a manual task where We have to append the contents of 'Previous actions (J)' into 'Log(I)' and then replace 'Previous actions (J) with 'Next Actions' (K). This is a rather tedious and repetitive task but I am struggling with automating it in excel.
LOG (I) | PREVIOUS ACTIONS(J) | NEXT ACTIONS(K) | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
In the example above, I would need first "04/06 - OLD UPDATE" to go into the bottom of the "LOG" column as a new line under 09/04 ****, then I would need
"14/06 - NEW UPDATE" to replace the contents of the "PREVIOUS ACTIONS " column.
I'm totally stuck and don't even know where to begin. If anyone would be able to help at all, I would be extremely grateful.
Thank you very much in advance.
Regards
AnnPan