You have chosen to sponsor your bid up to a maximum amount of .
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.