+ Reply to Thread
Results 1 to 6 of 6

How to program streaming data copy n paste in VBA ?

  1. #1
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    296

    How to program streaming data copy n paste in VBA ?

    Suppose cell A1 is having streaming data which is constantly changing.
    How can we code to copy and paste the data in A3 downwards( A4, A5 etc) every time the value changes in A1.
    Thanx for ur help !

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    6,516

    Re: How to program streaming data copy n paste in VBA ?

    You can use this macro to update data every second.Once it starts running it will not stop automatically.

    To stop macro
    Press Esc Key
    Then End Button in dialoguebox.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    296

    Re: How to program streaming data copy n paste in VBA ?

    Thanks a TON ! Will try and let you know

  4. #4
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    296

    Re: How to program streaming data copy n paste in VBA ?

    Dear kvsrinivasamurthy ,
    The code does not copy and paste any values

  5. #5
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    296

    Re: How to program streaming data copy n paste in VBA ?

    Please tell me how to do it..... Unless new values are registered in new cells I will not benefit from the DATA. Thanx

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    6,516

    Re: How to program streaming data copy n paste in VBA ?

    Pl see the attached file. Macro is working OK.
    In this file I added one for test purpose.Which shows it is working ok.
    If still problem is there,upload the file(If possible how it auto updates.)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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