Results 1 to 3 of 3

Thread: Data Web scraping

  1. #1
    Neophyte macaw's Avatar
    Join Date
    May 2018
    Posts
    2
    Articles
    0
    Excel Version
    2013

    Data Web scraping



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I am using excel 2013. I am importing data from a website. In a cell the data is being updated every 1 minute. (Let`s call it primary cell)

    I am copying the primary data in another cell but I want to keep the primary data in the first cell and not updated. Once the primary cell is updated I need in the second cell and so on and so forth for the next 14 cells. Once it reaches the 14 th cell I need to replace the first cell with the second cell and so on and so forth with all the 14 cells.

    Is it possible with excel 2013?

  2. #2
    Acolyte Iloveexcel&excelloveme's Avatar
    Join Date
    Jun 2017
    Posts
    25
    Articles
    0
    Excel Version
    2016
    Have you tried PowerQuery?

  3. #3
    Neophyte macaw's Avatar
    Join Date
    May 2018
    Posts
    2
    Articles
    0
    Excel Version
    2013
    Quote Originally Posted by Iloveexcel&excelloveme View Post
    Have you tried PowerQuery?
    Yes I use PowerQuery to import data from web but I don`t know how to apply my needs as described. Do you have a link on how to do it so I can continue my project?

Tags for this Thread

Posting Permissions

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