I have a fixed range of data and I need to add a date & time stamp for all the rows
in the range. The date and time stamp needs to be added to the first blank column
found.
The date & time stamp would need to be updated periodically (maybe every two seconds).
The range of data begins in cell A1.
Would anyone know how to do this please?
What is the reasoning behind applying a time stamp and then changing its value every two seconds? You might as well show a clock. Does the data change every two seconds? How?
Can you explain in context what you are trying to achieve?
Hello,
Thanks for your quick response. I am receiving streaming data and I need to time stamp
it before inserting the values into sheet 2. This way, I will have a record of the data received together with when I received it.
Last edited by teylyn; 03-14-2010 at 06:01 PM.
please don't quote whole posts. It just creates clutter.
If your time stamp changes every 2 seconds, you might as well apply the time stamp when you insert the data into sheet2 (however you do that).
How many cells of data are we looking at? Excel might become very busy to update hundreds of cells every two seconds.
How do you get the data from Sheet1 to Sheet2?
Put this code in the Workbook Module
Code:
Put this code in a general module
Please Login or Register to view this content.
Code:
Please Login or Register to view this content.
The above code is set to run every two seconds (set in Sub StartTimer)
mamba, next time you need to change a post, can you please edit the old post instead of creating a new one? Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks