Firstly i am taking some live xml data in to sheet1 , sheet2 , sheet3 and fixed refreshing time period is 3 mints ...
I wrote micro files(Alt=F11) for sheet1 ,sheet2 and sheet 3 as follows to Get the column "/WIN/RACE/OUT" at diffrent refreshing times.. with following code...
Dim i As Integer
Dim val As String
i = 7
While (Cells(20, i) <> "")
i = i + 1
Wend
Dim k As Integer
If i = 1 Then
k = 1
Else
k = i - 1
End If
If (Cells(19, k) <> Cells(3, 3)) Then
Cells(19, i) = Cells(3, 3)
Cells(20, i) = Cells(3, 10)
Cells(21, i) = Cells(4, 10)
Cells(22, i) = Cells(5, 10)
Cells(23, i) = Cells(6, 10)
Cells(24, i) = Cells(7, 10)
Cells(25, i) = Cells(8, 10)
Cells(26, i) = Cells(9, 10)
Cells(27, i) = Cells(10, 10)
Cells(28, i) = Cells(11, 10)
Cells(29, i) = Cells(12, 10)
Cells(30, i) = Cells(13, 10)
Cells(31, i) = Cells(14, 10)
Cells(32, i) = Cells(15, 10)
Cells(33, i) = Cells(16, 10)
Cells(34, i) = Cells(17, 10)
End Sub
Out Put At 1st refreshing time intervel
but if missing any live xml rows (or) adding any New Rows in live data in sheet then change the order like as below..at 2nd refresh time interval with 2 rows missed in live data.
and output at 3rd refreshing time intervel3 with 4 rows missed in live data.
If online live data changed my below sheet table changed by cells, Can I retrieve the data in single table followed by Date,Coruse Columns like refresh 1,referesh 2,refresh 3 …like this..
can I Any one Help me in Macro Coding To Get Live Data in single Row formate either adding any live data or removing any live data..?...like as fallows..