Extract data from Web/pull data from web through excel

  • Hello All,


    I'm new to excel and i need support here. I have list of links in column A in excel sheet1.
    I want macro to open the link and copy all data from webpage and paste it in sheet2 one after another.


    Please help..


    Tks in advance for your support:)


    Best Regards,
    Vikram

  • Re: Extract data from Web/pull data from web through excel


    I need solution here. In column A of sheet1 i have links (Approx 500 links) and first time it will ask for the login and password.
    Once the webpage is open i would like macro to copy entire data and paste in sheet2

  • Re: Extract data from Web/pull data from web through excel


    Kyle,


    I have similar query and hope you may help.


    I have an Excel that contains the following:


    Sheet1 - Col B with name & Col C with URL


    Requirement: Extract webtable 6 for each of these URL's and save it on Sheet-2. Also, the # of rows per URL may vary. Hence, it should find the last populated value in Col B and start from next row.


    Sample Macro recorded:


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!