I recently joined a golf group of about 40 people. Twice a month, a couple of my buddies have to go a website and look up everyone's new handicap index. They've been doing this for years and constantly complain about the amount of time it takes to do this. I know there's got to be a way to make this very easy. I tried to use "Get External Data from Web", but the site is not formatted to where Excel sees it as a table. However, when I right click on the section I do see some information in there that may allow for the lookup to be automated. I am fairly familiar with using VBA in Access, but not much at all for Excel. If anyone could offer some help to automate this process it would be greatly appreciated.
The attached Excel file is an example of the information needed to lookup handicaps. Each golfer has a GHIN number. The website offers the ability to lookup handicaps one at a time or multiple golfers at a time. The web address is: http://www.ghin.com/lookup.aspx
Thanks for any help.