Hello, Im new here and struggling to find any information on this, hopefully I can describe this well.

I have an excel document, there are a number of projects on there and one of the coloums is called 'comments'.

I type monthly updates into this but I would like to create an audit log type thing on another excel document basically automatically recording the comments I type into the comments cell into a new row of the another excel document. and another cell recording the date these comments went in.

is anyone able to help me with a code? or can anyone tell me if this is possible?

it would be much appreciated

and thank you in advance