Web data to excel without erasing while refreshing

[Afroo]

I have the data form a web page and i configurate it to refresh every 5 minutes, but every time it refresh,the old numbers disappear and new ones appear in the same place than the old ones. How can I save those numbers with a function without me copying and pasting the old values before they disappear? (a function that do it alone o where can i change the configuration for that?)

[NeedForExcel]

You cannot save it with a function.. You will need VBA to do that I am afraid..

[projectatpel]

Do you want the data to be saved to a new sheet every time or appended to the same sheet?
If it is a new sheet, First record a macro mocking how you copy data and paste it and lets ay you name that macro as "COPY_PASTE".
then use the following code to call that macro to be executed at a 5 min interval.
Better create a time stamp cell in your main data so that you get to refer the time as to when the macro was executed.

Please Login or Register  to view this content.