Hi-
I'm having problems using web queries to analyize a list of data in regards
to performance horse sales for the year 2005. In the sales that I'm looking
at, there are about 2000 horses and I need to find out how much each one
earned. I have an excel sheet that I have all of the horses names in one
column but I've been having difficulties with getting the internet to return
the values that I need.

Here is how to do it manually
Look up the horse's name in the column
go to http://www.nchacutting.com/cgi-bin/horseinfo.pl?2
enter the horse's name in the dialog box and click
resulting page URL is http://www.nchacutting.com/cgi-bin/horseinfo.pl?3 and
has horse earnings data

Is there any way to use a web query for this? I couldn't get the web query
wizard to get what I needed so then I tried playing around with .iqy files
but I wasn't sure what to put after:
WEB
1
http://www.nchacutting.com/cgi-bin/horseinfo.pl?2

or if that's even what I should be using. I'm assuming that if I could get
the web query to work, I'd probably have to use some if statements to filter
out the earnings data that I want into a seperate colums.

Here are a couple of horse names that are in the system if you'd like to
play around with it:
High Brow Cat
Smart Little Rondee
Mecom Blue
Royal Boonsmal
Peptoboonsmal
Royal Fletch
Smart Little Lena

At first glance, this looks relatively easy but has proved to be exceedingly
difficult. Any help would be much appreciated! :) -Katy