Hi Mike

If Rnum is the row number you copy to

This will add the date

Cells(Rnum,"L").Value = Date

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"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