Do you really want the date duplicated on every new row, or just once at the
start of a new day's data? It would be helpful if you included your present
macro so we could modify it to work properly.

Mike F
"mikerobe" wrote in message
...
HI
I hope someone can help. I run Macro in Excel to add new records from
a text file to the bottom of an excel sheet on a daily basis.
Therefore the number of records in the sheet grows daily. There is
data in each column up to column K. I would like to be able to add
todays (being the day the data is added to the sheet) date to Column L
when each new record is added while running the Macro.

Is this possible.

Thanks for any help
Eddie