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