Dear all

I have a simple problem and a difficult problem.

Simple:
I have two columns in a worksheet. I have written a code for a macro
that enters today's date in the second column, then converts it to a
value - i.e. not =today(). I want that code to be executed when any
value is entered into the first column.

e.g. If text is entered in A1 and A1 is clicked away from - B1 is
populated with =today(), then copied and pasted into a value (via the
macro I have already written)

Difficult:
This is an extension of the simple problem, but need help creating a
more complex macro to solve the below-
I have a worksheet that contains an unlimited number of rows. I need a
macro to be run to populate Column B with =today(), then copied and
pasted into a value, when a value has been added into Column A.
However, I need this macro to work for any row within Column A & B.

e.g. If text is entered in A1 and A1 is clicked away from - B1 is
populated with =today(), then copied and pasted into a value. And this
macro will work if text is entered in A100 and A100 is clicked away
from - B100 is populated with =today(), then copied and pasted into a
value.

Can anyone please help with either the above problems???

Kind Regards

Iain