Hello,

I am looking to convert information from a website to Excel. I am using the following website: http://hansard.millbanksystems.com/commons/ This is the website for the UK Parliament.

The website allows you to search for terms used in parliament over the past one hundred years (and more). It allows you to select the decade, year, month and date for a term that you search. The results appear on multiple pages. I want to be able to search for a term, for example "energy" in the period of the 1980s. You will see on the website that you have to click a button to select the decade, there is not a drop-down menu or free-text field. The results also appear on multiple pages.

I would like to be able to search a term (like "energy") in a certain period (for example the 1980s) and have the results in an Excel spreadsheet with columns for the Member of Parliament, the name of the discussion, the exact date and the quote that is listed in the results. Do you think you can help? It is certainly challenging for me!

Thanks?