Thread: Create columns and copy data

Now this may be easy for you all but I am no Excel wiz. I have data being displayed in real-time from a PLC to a cell in Excel. What I want is to create rows with a time and date stamp and that real-time data. So, every minute I write row with the time, date and that cells value then in a minute create a row below that and so on and so on.

Again, this maybe easy so please excuse me if this is Excel 101. Thank you in advance.

First this is not an 101 issue. for this you have to run a macro. I have included the macro as follows

Option Explicit

Public dTime As Date
Sub Increment()

    Dim i As Long
    
     i = Cells(Rows.Count, "E").End(xlUp).Row + 1
     
    dTime = Now + TimeValue("00:00:05")
    Application.OnTime dTime, "Increment"
    Range("E" & i) = Now() & " -- " & Range("A4").Value
    
End Sub

I appreciate the quick response. Can I tie this into some sort of Start/Stop button? Like a toggle so it only logs when we want it to.