Concluído

Copy Streaming Data in Excel into Data Table in same Workbook

Hi there, pretty simple request but having a difficult time using simple capture routine to do this properly.

1. I have several rows of live data streaming into my excel worksheet.

2. I want to capture the data every 1 minute and paste this data into another worksheet.

Can someone please provide the VBA code that will allow me to do this. I did notice another thread but this code isn't working for me:

Dim I As Integer

Sub Capture()

If I = 0 Then I = 1

Sheets("Sheet2").Cells(1, I) = Sheets("Sheet1").Range("A1")

I = I + 1

[login to view URL] Now + TimeValue("00:05:00"), "Capture"

End Sub

Thanks again.

Habilidades: Excel, Visual Basic, Processamento de dados, Processamento de Dados, Visual Basic para Apps

Veja mais: excel simple macro data comparing copy, macro find data copy cell excel, write excel file dataset data table, excel data streamer arduino, how to save real time data in excel, data streamer add-in excel download, excel data streamer workbooks, real time data analysis in excel, how to pull data from a website into excel 2010, c# read excel file into datatable using interop, excel stock data, vba excel charts show data table, excel pivot table change data source, load pivot table source data excel, excel connection sql pivot table reading data, copy number excel data, store data excel table asp, excel macro export data workbook, convert raw excel table data pivot table results, convert table raw data excel

Acerca do Empregador:
( 20 comentários ) Toronto, Canada

ID do Projeto: #25328282

Concedido a:

TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$30 CAD em 1 dia
(441 Comentários)
7.2

10 freelancers estão ofertando em média $19 nesse trabalho

sparkingboy2010

Hi, I can help you with your project according to your requirements. I am interested in your project. I am an expert in web search and data entry. I ensure i will complete the task successfully and within the specifi Mais

$20 CAD em 1 dia
(334 Comentários)
7.2
wkcompany

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many p Mais

$20 CAD em 1 dia
(61 Comentários)
5.1
arunkumar9896

Hi I will be able to edit this code and make it workable quickly. please connect . I have been exposed in development in vb script and excel dashboards, macros for 3 years in all discipline. For me, client satisfacti Mais

$15 CAD em 1 dia
(5 Comentários)
3.1
Umerfarooq92912

I will complete this project for you. It will be a high quality work covering all your requirements. Waiting for your message to discuss more. Thank you, Umer Farooq You can also hire me directly by clicking the Lin Mais

$20 CAD em 1 dia
(4 Comentários)
2.5
$15 CAD em 1 dia
(0 Comentários)
0.0
ismailabid77

I've 3 years' experience in Excel and I'm offering my help to finish the job you wanted as I'm well organized and will give you the best performance.

$20 CAD em 1 dia
(1 Comentário)
0.0
sachinjena987

I hope you will be happy with my work.i can be done this type of work in very little time as you don't expect.

$20 CAD in 7 dias
(0 Comentários)
0.0
Sudhanshu419

my dear client, I have deeply knowledge of Excel and web searching. and I have a one year experience in mnc company as a computer operator. and I assured you that you will be very happy after my work nd my behavior. Mais

$15 CAD in 2 dias
(0 Comentários)
0.0
sathish3245

I can complete this in a hour. If u are ready with me just drop me a msg. I'm an excel macro specialist??

$15 CAD em 1 dia
(0 Comentários)
0.0