Hi

I am working with Excel for a research project that I am working on and have reached a roadblock. My goal is to get collegiate data from over 100 quarterbacks. I have created a web query that looks like this:

WEB
1
http://www.sports-reference.com/cfb/players/["name","EnterName"].html

Selection=passing
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

Every time I run it it pulls up a dialog box and I enter a specific quarterbacks name and it pulls back the data. This is working great however I want Excel to somehow step through a list to pull data one at a time from all 100 quarterbacks and compile all that data into one big list, so that I do not have to enter each quarterback's name individually.

Another thing to note is the data is coming into excel in four rows so if I can create a loop or something like that will the data be overwritten by the next quarterback's stats and if so how do i remedy that?

I have very little training in VBA I just know basic computer programming functions so any or all help would be greatly appreciated.

Thanks so much, feel free to ask me for clarification.