Thread: Getting Data from Web - where the URL is the value of the active c
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aegoodrich aegoodrich is offline
external usenet poster
  
Posts: 3
Default Getting Data from Web - where the URL is the value of the active c
I have a list of about 200 URLs in a column in excel.

I want to write a macro that will:

Active Cell is A1. A1's value it the text
http://web1.ncaa.org/d1mfb/2002/Inte...09teamoff.html

I need the macro to go to the webpage, get the data from Tables 3 and 4 on
the website, and paste them in a new sheet
Reply With QuoteReply With Quote