VBA for Automatically copy Row data to new worksheet every minute?

  • Hi!


    I am looking for help on VBA for automatically copying contents of a row to another worksheet per minute.
    Have seen some codes on the internet but they are all dependent on every time a row's/ cell's contents are updated not on a per minute basis.


    Sample file with example display of the current data from live data feed from monitoring instruments and the worksheet for stored data is attached.
    I would be looking for around 400 rows of data while monitoring a total of around 1000 columns of instrument parameters.


    Thanks.

  • Re: VBA for Automatically copy Row data to new worksheet every minute?


    Hi..


    A quick search brought some handy code made by a bloke called Jerry Beaucaire...


    Paste this code into a Module and add 2 Buttons (1 to start the clock and 1 to stop it..)




Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!