Copy a live updating table every 5 minutes and paste it in sequence.

[AkashG]

Hi,

I am not much into programming & have been trying on this without success since 2 days! Need help...

I have values in the table A1 X L12 (12 x 12 Matrix) which updates every 5 minutes from a web page. Now I need to copy that every 5 minutes and paste it in another sheet, consecutively in sequence. So at the start of time, 0th minute, say the table will have values "1" all over the cells from A1 X L12. Now at the start of 6th minute, the live values change to "2" all over the cells from A1 X L12. So now i need this new tables of values "2" to be below the old table of values "1" in sequence.

Can anyone help me with the code for this.

Any help is highly appreciated.

 

[Legacy 456155]

Any success using the OnTime or some other method? Just checking up. I don't know when I will have the time necessary to help you out.

 

[AkashG]

Hey

Any success using the OnTime or some other method? Just checking up. I don't know when I will have the time necessary to help you out.

Hey! I got it done. Thank you so much for your time

 

[Legacy 456155]

Glad to help you help yourself!