Hi Everyone,

I have a cell range that refer to an external data using Web Query. This external data is refreshed every one minute. I need to copy the content of the cell range into another cell range every one minute, each time copy to the next cell in column and in the same time to have a time stamp.

Example: cell range "A17:A26,A28,A30" has the content that refer to an external data. The range is updated every minute. I need it to be copied to cell C1:N1. One minute later I need it to be copied to C2:N2 and so on, and than I need to make a line chart out of it using the time stamp values from column B for X axis and all the other values C:N on Y axis on different colors for the values of each column.

Beside this the data in every cell in the range A17:A26 has the following pattern: (1464, 13). I need to extract only the number 13 which is updating in order to make the line chart. Here is an example:

(1464, 13)
(1473, 1)
(1476, 0)
(1497, 0)
(1491, 0)
(1498, 0)
(1467, 0)
(1466, 0)
(1465, 0)
(1496, 0)


Same for the cell A28: capacitatea este 14 , I need to extract only the number 14 which is updating (the text "capacitatea este" remains the same)
Same for the cell A30: Suma apelurilor pe cisco este 14 , I need to extract only the number 14 which is updating (the text "Suma apelurilor pe cisco este" remains the same)

I hope this is clear enough.

Thank you in advance.