Excel Automation Project

---

---

We are a high-end luxury real estate company in Miami Beach, and I’ve been tasked with creating an automated Excel system that allows us to keep our spreadsheet evergreen. To give you an idea of the scope: we’re looking to develop a master spreadsheet that contains all active, pending, sold, withdrawn, and expired real estate listings in our area. Ideally, we’d like to update this spreadsheet automatically using new information from another spreadsheet. We would like to find a way to update one spreadsheet with another automatically, and to check for discrepancies. Moreover, we would like to find a way to have multiple tabs for better organization that update based on the condo building, area, and price. This information would again be linked to one main page and update automatically in an ideal world. I am looking to find someone that can help with the vision for the function of this. PERSONAL QUESTIONS 1) Is this something you have done? 2) Is this something you could help set up? 3) Do you work "office hours" / what is your availability? PROJECT NEEDS 1) Create a spreadsheet with all active, pending, sold, cancelled, and expired listings with data sets from the MLS. 2) Create sheet tabs connected to the master spreadsheet that group all active, pending, sold, cancelled, and expired. These sheets should populate automatically based on building, price point, and area. These sheets should update automatically when the information is added or edited on the first sheet. 3) Create a spreadsheet system that will update one spreadsheet with the latest data from another sheet.

Keyword: Data Processing

Price: $30.0

Data Processing Microsoft Excel Automation