Help With Importing Multiple Web Reports Into Excel

[tjeacret]

Hello. I am working on a report for my team at work. What I have done so far is used the online reporting we have to save the reports I need to compile to build a performance dashboard. Each report has a specific URL and I have 22 URL's I need the data from to make the report function. I have all the URL's pasted in individual cells starting with A1 down to A22. I am needing something in Excel to tell it to open hyperlink in A1, export the data to sheet Sheet2, then move to A2 and export to Sheet3 and so on and so on. How do I get this done correctly?

Thanks for your help!

 

[John_w]

Have you tried a web query? If it works use the macro recorder with you creating a web query to import one of the URLs, then edit the code to loop through cells A1:A22 and have the web query retrieve the data onto the appropriate sheet.