Vba Projects

Excel Real Estate Deal Analyzer - VBA

I'm seeking an experienced Excel developer to create a professional real estate investment analyzer tool. The tool should enable quick analysis of investment properties in a clean, well-designed single-sheet interface that supports multiple investment strategies. Key Requirements Functionality Create a comprehensive real estate investment calculator in a single-sheet design Include analysis for multiple investment strategies: BRRRR (Buy, Rehab, Rent, Refinance, Repeat) strategy DSCR (Debt Service Coverage Ratio) loan analysis Cash purchase with refinance option Implement dynamic elements that change based on selected investment strategy Create professional financial calculations for ROI, cash flow, debt coverage ratios, etc. Include conditional formatting for visual assessment of deal quality Develop a recommendation engine that evaluates deals based on key metrics Technical Specifications Microsoft Excel (compatible with latest version) VBA for button functionality Cell protection to prevent formula corruption Data validation for proper inputs Professional design with consistent color scheme and typography Design Requirements Clean, professional aesthetic with consistent color palette Intuitive layout that doesn't require switching between tabs Clear visual hierarchy with section headers Conditional formatting to indicate good/bad values Input fields clearly distinguished from calculated fields Deliverables Complete Excel workbook with all functionality implemented Basic documentation explaining how to use the analyzer All calculations visible and explainable All VBA code properly commented Skills Required Advanced Excel (formulas, conditional formatting, data validation) VBA programming Financial calculations knowledge UI/UX design sensibility Understanding of real estate investment calculations I have a detailed specification document prepared that outlines the exact layout, formulas, and design requirements for this project, which I will share with the chosen freelancer

Need dynamic excel drop down menu list built in

I need drop down menu built in either vba or power query.

opportunity

VBA Devloppment

I am reaching out for your expertise to develop a VBA macro that will automate the management of an interactive form in Microsoft Word. Below are the details of my request and the expected outcomes. Context: I am working with a Word (.dotx) template used to generate personalized offers. This template includes specific tags for managing optional sections and merge fields for inserting dynamic data. The tags in the document are as follows: [COMMUN]: Sections common to all offers. [OPTION ...]: Tags indicating optional sections (complete list below). The merge fields to be handled are: [DATE VALIDITE]: A date in the format DD/MM/YYYY. [NOM_CLIENT]: The client's name. [PROJET]: The project type. Request: I would like a VBA macro that automates the following tasks: Dynamic UserForm creation: The form should include: Checkboxes for each optional section (tags [OPTION ...]). TextBoxes for the merge fields [DATE VALIDITE], [NOM_CLIENT], and [PROJET]. A button to validate the user's choices and apply the changes to the document. Management of optional sections: Based on the checkboxes selected in the form, the corresponding sections should be included or removed from the document. Merge field replacement: The form's text fields should allow the user to input values that will replace [DATE VALIDITE], [NOM_CLIENT], and [PROJET] in the document. Expected Outcome: An interactive UserForm: Displays checkboxes for each [OPTION ...] tag present in the document. Contains text fields to populate the merge fields. A personalized document: Sections corresponding to [OPTION ...] tags are included/excluded based on the form selections. Merge fields [DATE VALIDITE], [NOM_CLIENT], and [PROJET] are replaced with the entered values. Clear and maintainable VBA code: The code should be structured to allow easy addition or modification of options or fields in the future. Complete List of [OPTION ...] Tags: [OPTION JDF] [OPTION VOLIGEAGE] [OPTION BARDAGE AJOURE] [OPTION BARDAGE RL] [OPTION BARDAGE CLIN Partie fermée ou brise vue] [OPTION BARDAGE AJOURE Partie fermée ou brise vue] [OPTION OSSATURE Partie fermée] [OPTION TOITURE DEMI CROUPE] [OPTION TOITURE ŒIL DE B] [OPTION TOITURE TOITURE BETON] [OPTION TOITURE TOITURE TC] [OPTION TOITURE TOITURE ARDOISE ART] [OPTION TOITURE TOITURE ARDOISE N] [OPTION TOITURE TOITURE PANNEAU TUILE] [OPTION MONTAGE] [OPTION MACONNERIE] Technical Notes: The form should be generated dynamically to adapt to additional options or fields in the future. A scroll bar should be added if all the checkboxes cannot fit within the visible window. The form should open via a simple macro (e.g., AfficherUserForm). Expected Deliverables: A .docm file containing the VBA macro and a functional example based on a Word document template. A brief explanation of how the code works. Thank you for your valuable help. Please don’t hesitate to ask if you need clarification or additional details. Best regards,

opportunity

Programming user forms in EXCEL (VBA).

I have an Excel database that needs programming for several user forms. each form needs save, replace, delete and reset functions. MUST have experience with Excel, VBA and programming user forms.

Help with BigQuery Authorization via REST API to excel

We're looking for a specialist to help resolve an issue with Google BigQuery authorization via REST API. Since there's no official SDK for Excel, we're implementing it at a basic level but are encountering authentication issues. Requirements: Experience with Google BigQuery REST API authentication Familiarity with OAuth 2.0 and service account setup Knowledge of integrating BigQuery with Excel (VBA, Power Query, or other methods) Ability to troubleshoot and guide us through the correct implementation Please provide details on relevant experience and how you can help.

opportunity

Developer for Web Scraping & Excel Automation (Car Market Data)

I am seeking an experienced developer to help automate data collection for my car rental business. The project involves web scraping used car valuations, auction results, and competitor rental pricing, then integrating the data into an Excel dashboard. Scope of Work: 1. Web Scraping Data Sources: - Used car valuations (Auto Trader, BCA, Manheim, CAP HPI, etc.). - Auction prices and historical trends. - Competitor rental pricing (Enterprise, Hertz, Sixt, etc.). 2. Automation & Data Integration: - Extract and clean data from dynamic websites (some may require Selenium for JavaScript-heavy pages). - Store and update scraped data in an Excel-based dashboard (Power Query, VBA, or Python integration). - Schedule automatic updates (daily/weekly). 3. Optimized Data Storage & Reporting: - Ensure data is structured for easy analysis (e.g., vehicle model, price trends, best resale timing). - Provide recommendations for API integration if relevant. Requirements: Proven experience in web scraping (BeautifulSoup, Scrapy, Selenium, or similar tools). Strong Excel automation skills (Power Query, VBA, Python-Excel integration). Experience scraping dynamic websites that require interaction (e.g., form inputs, AJAX content loading). Ability to ensure IP rotation and anti-blocking measures where needed. Bonus Skills (Preferred but not required): API integration experience (CAP HPI, telematics providers). Previous work in automotive data or pricing analytics. Budget & Timeline: Open to proposals, but ideally completed within 2-4 weeks. Payment structure: Milestone-based (initial scraping setup, integration into Excel, final testing). If you have relevant experience, please share past projects or examples of similar work. Looking forward to working with the right developer!

Excel VBA Macro Fix Required

We have a macro in one of our Excel spreadsheets (Office 365) that is not functioning correctly. The macro imports all the data from one tab of spreadsheet B into a tab of Spreadsheet A, and moves/formats the required information in sheet A into another tab, combining incoming stock numbers and dates. We need a VBA expert to modify our existing macro so it works correctly. It should be quite a quick fix for someone with the right knowledge of VBA.

Very quick VBA task

Task 1 - Calculate the target values (Cells D4:D6) In columns E, F and G, I want it to fill in calculated values in the range E24 to G28, but only the number of years specified in the cells in row 12. So if they select in row E12 "2" then it will only calculate the values in cells E24 and E25. Task 2 - create arrays to calculate the Assumed lower range and Assumed Worst Case I don't want these displayed on the sheet but I do what the values calculated into the range (E4:F6)

I need to PING email list

I am looking for someone that could write a VBA script to Ping a large list of emails in the aim to verify if the mail is still active or not.

Excel Auto filter

Hi All, a) I want to paste Raw client data into tab " Raw Data" in excel b) However I want the data automatically - when I flip over to the "Auto_Filtered_ClientData" tab to auto filter data i dont need to exclude eveything under a specific value ( in this case under 5) but to include Blanks and "-" C) once fitlered I also need it to sort it from Largest to Smallest in the Amount column of the Auto Filtered CLient data tab d) Any value in the amount column of "Auto_Filtered_ClientData" tab that has "-" or "#NA" this needs to be replaced with a zero "0". e) The Settings Tab - should be able to adjust values NOT to include each time ( so this can be adjusted in the future). I want to avoid Macro buttons , and VBA as much as possible (if at all?) - I just want to dump the raw data and then see the results populate automatically in the second tab "Auto_Filtered_ClientData" Thanks

Excel workbooks

I require the development of a sophisticated financial modelling solution for a construction company utilizing Excel. The overarching goal is to streamline cash flow forecasting and project costing processes. Specifically, the bidder will need to create a primary cash flow workbook that dynamically links to a secondary workbook to pull through updated financial data in real-time. Visualization of cash inflows and outflows over the project timeline will be integral. In addition, a robust pricing sheet is needed with intelligent linking capabilities. It must be able to read items from a master materials list andauto-populate values throughout various sheets for crafting accurate quotes. A further necessity is a workpack tool for drainage installation projects. This component should facilitate efficient planning and cost estimation of pipe laying, trenching and associated labour hours. Complex formulas will be required to derive material and labor costs based on supplied run lengths and installation details. The finished product demands a high degree of usability and flexibility. Intuitive interfaces and conditional formatting throughout are important. Ultimately, the solution will aim to significantlyboost productivity for estimating, budgeting and job cost control through an integrated Excel modelling approach. Professional verification of all formulas and links will also be expected. Fluency with Excel macros, VBA and array formulas combined with experience in the construction or project management fields would serve the bidder well in delivering this bespoke financial application successfully

Excel - Reconcilliation Sheet

Hi All , I am looking for part auto colour coding and part Data match reconcilliation sheet. After copying over data from the Client side in the "Client Raw Data" tab and my Company raw data in the "My Company Raw Data" tab in the results tab I want to try and match up the data to see where there is a break in the data set for me to investigate further. For the purpouse of making it easier to understand I have matched by line the client side and My company side results in the "Results" tab - however this my not be organised this way, as data on both side could be unfiltered or sorted or lines missing. So this is just so it is easier to view. I need a) Where there is a match for the cells to go green b) Company Name match - this is based off if the name fully matches on both the client side and mine or if an alternative name matches e.g Client name is Delta on the company side , however on my company side it shows as Delta 1. It has to search the Alternate name tab - to see if the alternate name matches or not? c) where there is an amount only match for example a message should appear in the Amount match cell " Exact amount found only) - thus I would need to investigate further. d) I need the colour coding as per the example - this is to help me work though the data and errors quickly as possible. I dont want to use macros or VBA - as I want to try and replicate this my self by looking at the formulas and colour coding myself. Thanks

Snapping polyline Code creator auto cad

I require the development of an AutoCAD plugin to facilitate polyline measurement with labeling. The plugin should enable the user to sequentially select points to create a polyline with horizontal and vertical segments connecting each point. As segments are added, the tool should provide the dimensional measurements of individual segments near their endpoint in a formatted feet/inches labeling scheme (e.g. 10'-5"). Segment endpoints should also be numerically labeled in sequence. Finally, a running total of the polyline length should be dynamically displayed alongside the drawing area. The goal is to expedite dimensional polyline creation and analysis in AutoCAD for layout and construction documentation. AutoCAD experience is essential to program the VBA or .NET based solution to meet drafting workflow needs. An example pictures is attached for what I’m looking for

urgent

Website scrape test: scrape just seven items from a website

I have a web scraping project. It's quite urgent but I think it is fairly straightforward and may even be possible using the Excel Power Query. There are no password issues and all data is publicly available. I am including to a link to a video for my client web site that shows the process to select the scrape data. Please view this before responding https://www.dropbox.com/scl/fi/n7xda6xvlq2x7e2h4u3or/Website.mp4?rlkey=t2sde1e5qaef6jl3gxrnlmwj2&dl=0 The client sells hundreds of different paint products from different manufacturers. This project is a proof of concept to prove that you can provide an automatic solution and acceptable output format to scrape just 7 of the products. Each Manufacturer supplies Product and Safety Sheets for the product. In most cases the Manufacturer sheets are downloadable via a link to the Manufacturer's site. Sometimes the client has the sheet stored in their own db. The client wants to scrape the website to be able to download every sheet into a single directory and produce an Excel sheet that has an index of the different products and also shows the url trail from the website. The sheet may have a completely different name from the website so we need to be able to index every sheet and be able to retrieve it. If this is something you are interested in I need you to prove the process with the following very simple Test Project ... To prove the concept and output formats I want you to just scrape the Product and Safety sheets for the seven paints in the Anti-Condensation category shown in the attached video tonight? We are only interested in the Product and Safety sheets. Some products have other sheets - we are not interested in these. Some products may have several Safety sheets we are interested in all the Safety sheets. Let me know if you think it can be done in Excel, a mix of Excel/Macros/VBA or using an alternative solution (and let me know what your alternative is). If you are successful with this project I will then create a new project to scrape the whole site. You must have excellent written English and preferably a track record of at least a dozen similar projects Please start your reply with the word Blackpool so that I know you have read to the end. ... and please dont just send some auto AI response. I am getting a bit tired of these Best of luck Chris

pre-funded

Excel VBA for weighted sum model

Hello, I am looking for a developer who can create a utility analysis in Excel with VBA. The task is defined as follows: - Create a utility analysis (weighted sum model) for an application example of your choice - The documentation and description of the application example is provided on an Excel worksheet. - The data management (criteria and alternatives) takes place in an Excel worksheet. - The weights for the criteria and their evaluation are queried in VBA and saved in the Excel worksheet. - The utility values are calculated with VBA and saved in the Excel worksheet. The following constructs are to be used in the VBA code: 1) Subroutine / subfunction with variable transfer 2) Array/Record 3) Data management in Excel using Application.Range (“A1”), Application.Value or Application.Cells(i,j) The task is to be submitted as an Excel file / Excel workbook with macros (xslm). The expected formula for the weighted sum model / utility analysis is to be found here: https://en.wikipedia.org/wiki/Weighted_sum_model Thank you for your interest and best regards

Looking for VBA Master

We are looking for a VBA programmer to modify legacy systems running on microsoft Access. You should have good experience of VBA programming. This is a longterm project because we have many scripts to work on, therefore we're looking for someone who can quote an hourly rate for the work.

VBA project to process data in Excel

The spec is in the Word document Essentially data will be pasted onto one page of an Excel spreadsheet each month and then 4 dynamics reports run from that. So on 4 pages of Excel there will be dropdowns to select the criteria and then I want to be able to hit a button to process the data from the data sheet into a report. Once I have selected the freelancer, I will share the Excel file.