copy data from sheet 1 to other sheet2 every 15 min

[krishna79]

Hello experts,

I am using currently using excel 2007. I have an excel sheet that copy live data from website (sheet1).

sheet2 i copy data from live data from sheet1 and add few formula on 2 different cell.

I request experts to help me. How can i copy calculated data from 2 different cell in sheet2 to different sheet3 every 15 min.

eg:-
time (sheet2 cell1) (sheet2 cell2)
9:15am 100 -50
9:30am 150 -200
.......
till 4 pm it should record every 15 min two different cell

Regards,
Krishna