Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question about Web Query
Hi there
I am using web query to get the stock data. I have set the Refresh Control to refresh the page every 5 minutes and on sheet1, the data is stored. On sheet2 I need the complete data for the stock update ie before every refresh the sheet2 should get updated. I am giving an example below: ---------------------------------------------------------- Sheet1 at 10.00 am Col1 Col2 ------------ 12 12.5 Sheet1 at 10.05 am Col1 Col2 ------------ 12.1 12.3 Sheet1 at 10.10 am Col1 Col2 ------------ 12.2 12.6 Sheet2 (which should get updated before every refresh) Col1 Col2 ----------- 12 12.5 12.1 12.3 12.2 12.6 ---------------------------------------------------------- Please help/guide me.... Thanks in advance aachiney |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One Last Query Question | Excel Discussion (Misc queries) | |||
Web Query question | Excel Discussion (Misc queries) | |||
MS Query question | Excel Worksheet Functions | |||
Web query question | Excel Programming | |||
Web query question. | Excel Programming |