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

Please Login or Register  to view this content.

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.