Hi all,

If it is ok to ask can someone please help me with the below.

I would like to create a kind of audit trail on my excel which basically will record the cell address of newly inputted data. How I had imagined is as follows:

There will be 2 sheets:
- a main sheet 'Home'
- a second sheet 'Audit Trail'.

The idea is that:
Step 1: every time a user types something in Sheet 'Home', a worksheet VBA will record the cell address of the newly inputted data.
Step 2: the cell address will be pasted in 'Audit Trail' in Column A.

E.g.That is, if someone types 'hello' in cell A8 of worksheet 'Home'. The macro will record A8 and paste it in 'Audit Trail'.

P.S Each time data is inserted in 'Home' the cell reference will be pasted in the last blank cell of Column A in 'Audit Trail'

Not sure if this is possible but would really appreciate a lot your help!!!

Thanks a lot guys!!
Keibri