+ Reply to Thread
Results 1 to 8 of 8

Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

  1. #1
    Registered User
    Join Date
    12-14-2019
    Location
    Bangalore, India
    MS-Off Ver
    2008
    Posts
    8

    Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    Hi,

    I am not much into programming & have been trying on this without success since 2 days! Need help...

    I have values in the table A1 X L12 (12 x 12 Matrix) which updates every 5 minutes from a web page. Now I need to copy that every 5 minutes and paste it in another sheet, consecutively in sequence. So at the start of time, 0th minute, say the table will have values "1" all over the cells from A1 X L12. Now at the start of 6th minute, the live values change to "2" all over the cells from A1 X L12. So now i need this new tables of values "2" to be below the old table of values "1" in sequence.

    Can anyone help me with the code for this.

    Any help is highly appreciated.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    .
    This is one method :

    Paste this macro into a ROUTINE MODULE :

    Please Login or Register  to view this content.
    Place a START and a STOP button on Sheet2 in N1 & N2 respectively.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-14-2019
    Location
    Bangalore, India
    MS-Off Ver
    2008
    Posts
    8

    Re: Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    Thank you so much for the prompt reply! It solved the problem but one small issue, the macro copies & paste automatically 2-3 times within the same time frame. if its supposed to update once every 10 seconds, it does it twice or thrice. Why So?

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    .
    It works as requested here.

    If you are using the example file and data on Sheet1 ... the data on sheet is not changing so it may appear it is copying / pasting more than once each time.

    Also .. the code as presented is set to copy/paste every 5 seconds. You will need to change the time segment to 5 minutes by adjusting the time setting :

    ("00:00:05") change to ("00:05:00")

  5. #5
    Registered User
    Join Date
    12-14-2019
    Location
    Bangalore, India
    MS-Off Ver
    2008
    Posts
    8

    Re: Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    Hello! Yes it does work

    And i did the change the time setting earlier. I did observe, when i do the run the macro 2-3 times trying different time settings, it does copy 2-3 times consecutively. Am not able share the excel file to give you a better idea.
    Or just try for time setting " 00:00:30", let it run for a couple of minutes, then try "00:00:15", now next time the macro runs, it'll paste two - three tables simultaneously.

    And again thanks a ton, for taking out time to reply!

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    .
    I am unable to reproduce what you are experiencing there.

    Sorry.

  7. #7
    Registered User
    Join Date
    08-01-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    8

    Re: Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    This is genius! Is there any way I could change this code to copy and paste special for values only? Currently its copying the whole formula.
    Thanks

  8. #8
    Registered User
    Join Date
    08-01-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    8

    Re: Copy a live updating table every 5 minutes and paste it in a new sheet in sequence

    This is genius! Is there any way I could change this code to copy and paste special for values only? Currently for me its copying the whole formula.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy a live updating value every 5 minutes and paste it in a new cell
    By kalidindi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-29-2020, 12:05 AM
  2. [SOLVED] Live copy of Table in other sheet
    By lbm12345 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2018, 10:55 AM
  3. Replies: 5
    Last Post: 01-31-2018, 09:48 AM
  4. Live-updating Transposed Sheet
    By jsf1212 in forum Excel General
    Replies: 1
    Last Post: 04-06-2015, 06:17 PM
  5. VBA to find minutes picker for an employee and copy and paste it to main sheet
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2013, 05:20 AM
  6. Copy & paste to another sheet in sequence
    By ankitsondhi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2013, 01:31 AM
  7. Macro to copy values from columns of one sheet & paste it to diffrnt Column Sequence
    By kmvasudha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 06:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1