API, VBA or whatever is best

Greetings,

First and most important, Thank you for reading my post and I appreciate any mentoring you can provide.

I am looking for some excel help with connecting, filtering and using a website API. I have an example of what I am doing by hand and I am looking to automate the process as much as I can.

Right now I have a row with airport codes along the top, I then have a row going down column B with my “local” airport codes. I then go to various websites and look up the cost for flying to the different airports. I have found that many times if I am willing to drive an hour or two I can save several hundred dollars. Then below that first table I do the same basic thing with driving. I list how far it is to the “local” airport. I have a column for estimation of gas, travel time and such. I would like to just enter the airports I am going to and then click a button to get my results. I don’t really care too much what site the data comes from as I only use this as a guestimation and I will hand check but it would be nice if I could feed it a list of sites to check. I tried with the Hotwire API and I got data back but it was a large data dump and it wasn’t filtered down like I thought it would be. I am not sold on this being excel but that is the best tool I have found so far. If this could be done easier with a java script or something then I am game. Is anyone willing to share their powerful wisdom and help me do a walk through? I will need very clear directions and help as I have no programming, scripting or advanced excel experience.

I have tried to attach my example and maybe it will help to show my work and give a picture vs my words