Thread: logging a xml feed-copy the same cell and paste into increasing cell positions.

hi

i have a xml feed which is updating 4 cells constantly, i would like
to log that value over 7hrs.

so far my macro can copy the cell, paste the value into a new cell,
then wait x seconds. the code so far is:

Sub start2()
'
' start2 Macro
'

'
   Range("B12").Select
   ActiveCell.FormulaR1C1 = "=R[-5]C[2]"
   Range("C12").Select
   ActiveCell.FormulaR1C1 = "=R[-8]C[1]"
   Range("D12").Select
   ActiveCell.FormulaR1C1 = "=R[-5]C[2]"
   Range("E12").Select
   ActiveCell.FormulaR1C1 = "=R[-8]C[1]"
   Range("E13").Select
   newHour = Hour(Now())
   newMinute = Minute(Now())
   newSecond = Second(Now()) + 5
   waitTime = TimeSerial(newHour, newMinute, newSecond)
   Application.Wait waitTime
End Sub

i just recorded a macro for the copy and paste steps and then googled
the code to wait. i realize this is probably really inefficient code
but im to new at this to really care. i can repeat this code manually
but im definitely not going to be able to write all the code out.


i would love to have the code that would repeat this step but lower
the paste cell each time. while the copy cell value is always
changing, the cell it self is constant.


any help would be appreciated, even if its the name of the process. i have asked this question before but i dont think i worded it very well. this was the answer i got.

Cells(Rows.Count, "D").End(xlUp).Offset(1).Value = Range("D1").Value

i dont really know how that fits into my code, but again any help at all would be great.

thanks