Excel VBA Expert Needed: Property Management Workbook with Forms & Dashboard
$10-30 USD
Teslim sırasında ödenir
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly.
=== Project Requirements
1. Single Excel File (.xlsm)
• All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook.
2. Multi-User Access & Password Protection
• Ideally, have basic password protection or user-level access within Excel:
• For example, an initial login form that requests username/password.
• Different roles (e.g., admin vs. read-only) would be great if possible.
• If Excel’s native password features are insufficient for strong security, please propose an alternative approach.
3. Data Sheets
• Properties: Property ID, name, address, notes, etc.
• Units: Unit ID, link to property, rent amount, occupancy status.
• Tenants: Tenant ID, personal info, linked unit, lease dates.
• Payments: Payment ID, tenant info, date, amount, method.
• Maintenance: Request ID, property/unit, description, cost, status.
4. User Forms (VBA)
• Add Property: auto-generate ID, store in “Properties” sheet.
• Add Unit: link to property, track rent, status, unit ID.
• Add Tenant: link to a unit, track lease start/end, contact info.
• Add Payment: track date, amount, method, tenant ID.
• Add Maintenance: log request, property/unit, status, cost, etc.
• (Optional) Edit/Update forms if needed, or a simple approach to updating existing records.
5. Unique IDs & Basic Validation
• Each record type has a unique, automatically generated ID (e.g., “PROP1”, “TEN1”).
• Prevent blank fields or obvious duplicates.
6. Dashboard (Detailed)
• A summary sheet that shows total properties, total units (occupied vs. vacant), overdue payments, open maintenance requests, etc.
• Could use pivot tables, charts, or formulas—must auto-refresh and be easy to understand.
7. Ease of Use
• Minimal direct cell editing: the user should rely on buttons and forms to add or update data.
• Provide short instructions on enabling macros, using the forms, and handling multi-user login.
8. Offline Use, But Multi-User
• The workbook might be stored on a shared network drive so multiple people can access it.
• If direct simultaneous use is tricky in Excel, we can adopt a system where only one user at a time can edit, or you can suggest solutions for concurrency.
9. Delivery
• Final .xlsm workbook, fully functional with user forms and multi-user password/access mechanism.
• A short “how-to” guide for using and maintaining it.
=== Skills & Experience Desired
• Excel VBA expertise (creating forms, macros, validation).
• Knowledge of multi-user scenarios in Excel (passwords, protected sheets, or custom login forms).
• Ability to create a clean, intuitive interface for non-technical users.
• Good English communication skills.
=== Deliverables
1. One Excel Macro-Enabled Workbook (.xlsm) with:
• Sheets: Properties, Units, Tenants, Payments, Maintenance, Dashboard.
• User Forms: For adding/editing records.
• Multi-User Login (username/password or role-based access).
2. Documentation: Brief instructions on how to enable macros, use forms, manage user/passwords, and update the dashboard.
Proje NO: #38986224
Proje hakkında
Bu iş için 21 freelancer ortalamada $32 teklif veriyor
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Daha Fazla
Hey! As an experienced Excel VBA developer with a strong background in creating user-friendly, macro-enabled workbooks, I'm excited about your property management tool project. My portfolio includes developing complex Daha Fazla
Hello, I'm excited to take on your project to create an Excel-based tool to manage your properties, units, tenants, payments, and maintenance tasks. With my expertise in Excel VBA development, I can create a user-frie Daha Fazla
Hi I’m an Excel and Excel VBA expert with 8 years of experience, boasting a 100% job success rate My specialties include Excel formulas, data conversion, analysis, and crafting user-friendly interfaces that drive resul Daha Fazla
Hello, I'm ready to start NOW on your Excel VBA property management tool. My expertise in Excel VBA and multi-user environments makes me the perfect fit for this project. - Comprehensive .xlsm File: Integrates all pr Daha Fazla
I am an expert in python, c programming, excel and matlab as I am mechanical engineer by profession. I also have experience in report and research writing and have recently written two submitted master dissertations in Daha Fazla
Hi Abdulrahman A. Good afternoon Already have something live to show you Live Similar Site work I have gone through your requirement , I found it very interesting , Since I already have similar live to show you As i Daha Fazla
Hi Abdulrahman A., I understand you're looking for an experienced Excel VBA developer to create a user-friendly tool for managing your properties, tenants, and maintenance tasks while allowing for multi-user access w Daha Fazla
HI can work on it.. Feel free to contact me. I am Christine and able to do that task for you! Thank you so much1
I am a skilled digital marketing expert who can help you grow your business's online presence. My services include: i am digital marketing expart. 1. Facebook Business Manager Setup & Optimization: Set up Facebook Pag Daha Fazla
I’m confident that I’m the perfect fit for your project. As a Software Engineer, I have extensive experience in developing user-friendly, secure tools for data management, which aligns perfectly with your requirements. Daha Fazla
Hi, I’m an experienced Excel VBA developer and would love to help with your project. I can create a user-friendly tool to manage properties, tenants, payments, and maintenance in one Excel file. It will include user fo Daha Fazla
As an MBA graduate with a keen interest in finance, I understand the importance of efficient data management and user-friendly interfaces. With my comprehensive skills in Excel and a thorough grounding in business anal Daha Fazla
Hey Abdulrahman A., I just finished reading the job description and I see you are looking for someone experienced in Excel, Excel VBA, Microsoft Office, Excel Macros and Visual Basic. This is something I can do. Pleas Daha Fazla
Hi there, Developing an Excel VBA tool for property management is a project that aligns perfectly with my expertise in creating efficient, user-friendly solutions tailored for multi-user environments. I’m excited to h Daha Fazla
I am excited to offer my expertise in Excel VBA development to create the comprehensive property management tool you’ve described. With a strong background in building user-friendly, macro-enabled Excel solutions, I am Daha Fazla
Hi, I am pleased to offer my services to develop an Excel-based property management tool tailored to your needs. This solution will consist of a single macro-enabled Excel workbook (.xlsm) that will manage your propert Daha Fazla
