Hello everyone,

Long time lurker here and have learned quite a bit of information about excel from this website. There is a repetitive task here where we import all the New York Closing Exchange Rates for the current year into Excel workbook. The wall street journal website link is http://online.wsj.com/mdc/public/pag...c_pastcalendar

Right now I am completing this task by pressing view spreadsheet for every single day in 2010 and then pasting the information into excel. Is there anyway to automate this process so that I don't have to spend days on compiling this database of closing currency exchange rates? The rates can be on the same spreadsheet. Ideally I would want to organize this information into dates later on so that a vlookup can pick up a certain exchange rate for the year.

Any help would be greatly appreciated.