Excel VBA Script - Trip Price and Availability Matrix

CLOSED
Bids
7
Avg Bid (USD)
$148
Project Budget (USD)
$30 - $250

Project Description:
Hello,

I require a VBA script written within Microsoft Excel that will go to Sandals.com AND Couples.com and will data mine the websites. Based on an example template (attachment provided), the user will provide the CHECK IN and CHECK OUT dates on the left, the VBA script will then find the cheapest available room showing the TOTAL PRICE, AVG PRICE PER NIGHT and ROOM TYPE (which is all info provided on the website) for the given resort and time period. Please note, if a particular day is sold out within the specified date range, the result should be "Sold Out".

Please review the attachment for a mockup.
I want excellent VBA written along with good comments.

On a personal note, when creating this matrix by hand, there came a point in time when the website required me to enter a verification code, to ensure I was a human, so you will need to figure out a way to bypass this.

Please ensure you understand this project and what is required before bidding.
Thank you.

Skills required:
Excel, Visual Basic for Apps
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: Trip Price and Availability Matrix.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 228
in 4 days
Hire northwolves
$ 120
in 3 days
$ 133
in 5 days
$ 122
in 3 days
$ 155
in 3 days
$ 127
in 3 days
$ 148
in 3 days