Date & Time of updating data

[StevenD]

Hi,

I import data every minute from a text file.

What i want to be able to do is.

When the data is updated, to put a date & time next to the last row in column m.

Hope this makes sense.

Thanks

Steve

 

[P Sitaram]

Is the Import automated? Do you have code in the workbook that does the import?

 

[StevenD]

It is automated.

I have cracked it as far as putting the date & time.

I think it is sorted now, I will post the code once I have verified that it is fully functional.

Thanks

Steve

 

[StevenD]

As Promised here is the code I used.

This puts the time and date of sheet update in column m of the last row updated.

Private Sub Worksheet_Change(ByVal Target As Range)

mynextblank1=sheets("Data").range("a65536").End(xlUp).Row
If Range ("m" & my nextblank1) ="" Then
Sheets("Data").Range("m" & mynextblank1)=Now
End if

End Sub

Thanks

Steve