How to program streaming data copy n paste in VBA ?

**omega0010** · 03-15-2013, 02:05 AM

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 !

**kvsrinivasamurthy** · 03-15-2013, 02:38 AM

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.

**omega0010** · 03-15-2013, 02:50 AM

Thanks a TON ! Will try and let you know

**omega0010** · 03-15-2013, 03:14 AM

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

**omega0010** · 03-15-2013, 05:26 AM

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

**kvsrinivasamurthy** · 03-15-2013, 05:31 AM

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.)