Search results for query: *

It's a live feed so I figured pasting values every 5 minutes using a VB Macro would be the easiest option. I only need it for 8 hours a day so I just need to populate 96 cells a day and save the results.

Thanks for that, Will that paste the values? I don't know how to do that. Thanks

Thanks for all your help guys, Just to clarify what I'm doing here, I'm taking a constant stream from 'Reuters' of Stock Prices. The Stream of price is constantly updating. I'm trying to track each individual component of the Indicie (F3:F32 relates to the streamed price). I want the macro to...

I want it to take values (F3:F32) from the 'Cover' Sheet, then paste the values in the 'dax history' sheet (B1:B30), then move over to (C1:C30), then paste values 5 minutes later.. and so on.

It doesn't seem to be working. I'm not sure why. I was wondering if anyone noticed something wrong in my code.

Hi All, I am trying to programme a Macro that takes values (F3:F35)from sheet ("Cover") every 5 minutes and displays the results on another sheet("dax history"). This is what I have so far: ------------------------------------------------------------ Option Explicit Dim mdNextTime As Double...

Hi All, I am trying to programme a Macro that takes values (F3:F35)from sheet ("Cover") every 5 minutes and displays the results on another sheet("dax history"). This is what I have so far: ------------------------------------------------------------ Option Explicit Dim mdNextTime As Double...