I have a sheet which updates throughout the day.

I am looking for VBA code to copy a value from E$1 to column A, third row, which will populate and update the column throughout the day.

I can specify cells in which to put specific values, eg 

Please Login or Register  to view this content.
Can the code for copying value on update be inserted here or is it more complicated?

Any suggestions greatly appreciated.

Grant.