VB for Copy single raw and paste with saving

Closed
BBhojani
Posts
1
Registration date
Saturday June 17, 2017
Status
Member
Last seen
June 17, 2017
- Jun 17, 2017 at 10:27 AM
Hello
Want to have code for copy single raw data which is refresh every minute and paste in other sheet in real time.

It is used in stock market analyses so for change in every 1 minute data need to paste & save progressively in other sheet.
i.e Copy and paste - 1st raw 9:15:00 with stock data(Open High Low Close and Volume)
2nd raw 9:16:00 and so on.. up to 375 data (9:15 AM to 3:30 Pm

Pl help providing code for the same
with regards
Baldev