+ Reply to Thread
Results 1 to 2 of 2

question about Web Query

  1. #1
    aachiney@gmail.com
    Guest

    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


  2. #2
    Don Guillett
    Guest

    Re: question about Web Query

    a macro to copy the values from the data sheet to the next available row in
    the destination sheet.

    with sheets("destinationsheet")
    x=.cells(rows.count,"a").end(xlup).row+1
    .cells(x,1)=sheets("sourcesheet").cells(1,1)
    .cells(x,2)=sheets("sourcesheet").cells(1,2)
    end with
    --
    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    <aachiney@gmail.com> wrote in message
    news:1137073913.614116.23440@g47g2000cwa.googlegroups.com...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1