Apartment Information & Ratings Finder

Executive Summary

            My project deals with the hassles of finding an apartment to live in. Generally you have to search online for each different apartment and see reviews and other information and it can be very annoying. My project takes the name of the apartment and the city that the user inputs and finds the address, the phone number, the website, and queries from the web ratings for the apartment and the number of reviews. This way you can look at current rating data that is constantly updated in real time and see the difference between many different apartments. My project has a user form which allows the user to insert, delete, or edit and save apartment information. It also has a ribbon button which allows the user to graph the results of the different apartments chosen and see who has the best reviews graphically. The project also creates a hyperlink for each website so the user can click on the website on the sheet and check out what the apartment offers. This will be useful to anyone who is looking at a large number of apartments and wants to compare ratings across different apartments. The main vba elements I used in creating this project was web scraping, user forms, and macros.

Project:
http://files.gove.net/shares/files/14f/mcook24/finalvbaproject.xlsm

Write-up:
http://files.gove.net/shares/files/14f/mcook24/ExecutiveSummary.pdf