Automatically Record Changing Cell Value ion Separate Sheet

Without seeing your workbook, I'm doing this by trial and error. The following code should do what you want

Please Login or Register  to view this content.

Change Sheet1 A2 in the attached, to see the value being added to sheet2 column A
Itsfurreal Automatically Record Changing Cell Value.xlsm

With the excel workbook open -
Press Alt + F11 (opens VBA editor)
In the Project - VBA Project pane on the left (usually) double click the sheet name that you want the code to be in (opens the editor window on the right (usually)).
Copy the code I posted and paste it into the sheet editor window on the right.
Then change A2 on the sheet you posted the code in.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

EDIT** I forgot, you have to change the Target Column to 2 instead of 1

I started thinking about it and realized that with the code, and changes, I provided, if you change anything in column B it will trigger the macro. SO, I have another change for you
Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

This will only trigger the macro when B9 is changed.

Here is the corrected code in full

Please Login or Register  to view this content.