Hello, I'm new to VBA and this is my first post.

I have a simple problem: create a historical record from a live
on-line data feed on Excel.

Here is the problem:

1. Excel Workbook with 2 worksheets: "DataFeed" and "Record"

2. The "DataFeed" worksheet has 2 Cells with Data Feed from Internet
continuously updated every second:
Cell A1 = Time Cell A2 = Quote

3. The "Record" worksheet is empty and I need a VBA module to record
the content of Cells A1 and A2 (from "DataFeed" worksheet") to Columns
A and B every 5 minutes

If the VBA module starts working at 09:00:00 till 09:55:00 I will get
12 rows of data on "Record" worksheet:
On column A I will have: A1=09:00:00; A2=09:05:00; A3=09:10:00 ...
On column B I will have: B1=Quote at 09:00:00; B2=Quote at 09:05:00;
B3=Quote at 09:10:00 ...

I think the problem is clear and objective.

.