+ Reply to Thread
Results 1 to 7 of 7

Is it possible to copy live data to row underneath and insert new row every few seconds?

  1. #1
    Registered User
    Join Date
    06-16-2017
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    3

    Question Is it possible to copy live data to row underneath and insert new row every few seconds?

    I am working on creating a live Excel Dashboard to monitor some machines. I have a program pulling information from a PLC and displaying it in Excel in real time, values change every second. I need a way to copy the values that are displayed to a row underneath and then insert a new row to copy values again. Essentially creating a FIFO cascade with the information that is displayed on the first row. I need to do this every couple of seconds. I want to then use that information to create a running chart or graph displaying the last 30 minutes of information in an easy to view format. Is this even possible with Excel and VBA?

    Thanks

  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: Is it possible to copy live data to row underneath and insert new row every few second

    .
    Post a simulated spreadsheet of your layout.

    Where is the data entered every few seconds on the sheet ?

    Where should the copied rows begin?

  3. #3
    Registered User
    Join Date
    06-16-2017
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Is it possible to copy live data to row underneath and insert new row every few second

    I attempted to attach a spreadsheet. Not sure if it worked properly. New rows begin one or two rows under the live data, which is near the top of the sheet.
    Attached Files Attached Files

  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: Is it possible to copy live data to row underneath and insert new row every few second

    .
    Paste this macro into the Sheet Level module:

    Please Login or Register  to view this content.
    The above macro presumes that A3 will always have new data added when the info on Row 3 is updated. In your case, the date is added with each new update of data.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-16-2017
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Is it possible to copy live data to row underneath and insert new row every few second

    Thank you. That's very close to what I need. However, it is moving the formula and leaving the cells empty. I need the formulas to remain in row 3 and only copy values below.

  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: Is it possible to copy live data to row underneath and insert new row every few second

    Give me a moment to rework this.

  7. #7
    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: Is it possible to copy live data to row underneath and insert new row every few second

    .
    Ok, if I understand your sheet correctly, A3 does not have a formula.

    So, try this and let me know :

    Please Login or Register  to view this content.
    I had included clearing all of Row 3 after the copy / pasting to make the sheet look more presentable. This change will only clear A3 which is the range the code is looking at
    in order to decide to fire or not.

+ 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. [SOLVED] Live Filter Copy by Non-Unique Data, Not in First Row
    By StPatty33 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2016, 03:13 PM
  2. Replies: 0
    Last Post: 12-04-2013, 10:39 AM
  3. [SOLVED] Copy text files underneath each other
    By ditöle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-05-2013, 07:28 AM
  4. VBA Halp! Sort Columns by date; Insert/add Data Underneath the Cell in Column B
    By goradiar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-06-2012, 09:10 AM
  5. Copy & Paste a row underneath the last one in the table
    By BouncingHippo in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 01-28-2008, 08:30 PM
  6. macro to copy a column and put it underneath another
    By cadalist in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-28-2007, 06:59 PM
  7. [SOLVED] Converting Julian Seconds with a macro to replace old seconds data
    By Keldair in forum Excel General
    Replies: 2
    Last Post: 02-17-2006, 08:15 PM

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