Vba Projects

Excel Makro / VBA Code needed

Hi We need an excel macro or VBA code which automatically puts bank statement page columns into columns automatically based on what is in the detail column. For example if the client is VAT Registered the vat amount is automatically calculated and the net figure goes into the appropriate column. For example Date / Detail / Amount VAT Registered - Yes / No If VAT Registered net figure it put into a VAT column (20%) If not VAT Registered Gross figure is put into the appropriate column - ie Telephone column is BT / EE / Vodafone / Three etc We will need a way to have a library page or another way to do it, that we can enter typical names of companies that will go into each column. I hope this makes sense

Macro Fix / Automation Quick Win (Excel VBA)

£75–£150 Automate a repetitive Excel process / clean-up / export / consolidation 1 workbook, 1–2 macros, 1 revision Demo: https://1drv.ms/v/c/ae7b3e70844b9d98/IQAUGrFbU-WGQ7KUe_BwHFCdASqFOKeTkBxHYe67Stane5k?e=n8XuN1

Excel Support - Macro

Excel Labour Tracker Required – Budget vs Actual Hours (Same-Day Delivery) Project Overview I am looking for an experienced Excel specialist with VBA / macro capability to design a labour tracking workbook that compares budgeted labour hours against actual hours spent. This is a design-only labour tracker (no cost tracking). The workbook must be macro-friendly, cleanly structured, and suitable for long-term use. ⏱️ Same-day delivery is required. This should be a straightforward build for someone experienced with Excel data matching and summaries. Core Functionality Required 1. Data Imports (Macro-Friendly) The workbook must allow easy importing of: Project List Budget List (budgeted labour hours per project) Timesheet (actual labour hours) Imports can be via: Buttons Defined import areas Power Query or VBA (open to recommendation, but must be simple for users) 2. Data Matching & Calculations Projects must match consistently across: Project list Budget list Timesheet Use clear project identifiers to avoid duplication Logic must calculate: Total budgeted labour hours per project Total actual hours spent to date per project Variance (over / under budget hours) 3. Project Selection & Summary Output User selects a project from a dropdown Workbook automatically displays: Budgeted labour hours Actual hours to date Variance Summary updates dynamically when: New timesheets are imported Budget data changes 4. Design & Usability Clean, professional presentation Clear separation between: Raw imported data Calculations User-facing summary Simple for non-technical users to operate Easy to expand for additional projects Key Requirements Excel only Macro-friendly design Clear, logical formulas No over-engineering Robust and reliable What I Will Provide Sample project list Sample budget list Sample timesheet Explanation of required fields Ideal Freelancer Advanced Excel user Strong VBA / macro experience Experience with labour tracking or project reporting Able to start immediately and deliver same day Timing Immediate start Same-day delivery required

Excel/VBA Specialist to Fix and Harden Production Stock Workbook

I run a small UK food manufacturing business and have an existing Excel workbook that manages: Daily production logging Frozen & chilled stock Inventory movements ledger Simple backlog / buffer planning The workbook already exists with tables, formulas and some VBA macros, but it needs: Debugging and stabilising (remove errors, type mismatches, fragile logic) Clean, reliable daily posting macro (production → stock ledger) Hardened structure so staff can use it safely Clear documentation of how to run it each day Scope is refactor + fix, not build from scratch. Requirements: Strong Excel + VBA experience Comfortable with manufacturing / stock logic Mac-compatible Excel (important) This is a short project (1–3 days). Goal is a stable, reliable production & inventory workbook I can hand to my team.

Coach Excellency Live Logger in Excel

Project Overview We want to build an Excel-based Coach Excellency Tracker for live football coaching sessions. The tool should: Track the total session time with a live timer. Record different activity types (Ball Rolling, Intervention, Transition) with live start/stop buttons. Capture the duration of each activity and accumulate it over the session. Display the proportion of each activity as a live pie chart (percentage of total session time). Allow multiple coaches to be logged optionally. This tool is intended for real-time use during coaching sessions. Functional Requirements 1. Session Timer A live timer cell showing the overall session duration. Start/Stop buttons to control the session timer. 2. Activity Logging Buttons for Ball Rolling, Intervention, and Transition. Each activity button starts a timer for that activity. A Stop Activity button logs the duration of the current activity. Durations are cumulative, so multiple interventions or ball rolling periods sum automatically. Optional dropdown to select Coach Name for multi-coach sessions. 3. Data Capture Sheet called DATA or Capture stores: | Timestamp | Coach | Event Type | Activity Name | Duration (seconds) | Each Stop Activity records: Timestamp of end Coach (from dropdown or fixed cell) Event type Activity name Duration of the activity 4. Live Dashboard Cells showing total time spent for each activity: Ball Rolling Intervention Transition Pie Chart updating live as activities are logged, showing percentage of total session for each activity. Optional: Bar chart for cumulative time per activity. 5. Buttons Start Session → starts total session timer Stop Session → stops total session timer Ball Rolling → starts Ball Rolling activity Intervention → starts Intervention activity Transition → starts Transition activity Stop Activity → stops current activity and logs duration Technical Requirements Must be built in Excel (.xlsm) with VBA. Timers must use Timer function or equivalent for live tracking. Pie chart must update automatically as activity durations change. All macros and buttons should be user-friendly and clearly labeled. Optional: Clear instructions on how to start/stop sessions and activities. Deliverables Excel workbook (.xlsm) with: Live session timer Activity buttons Cumulative activity tracking Auto-updating pie chart DATA sheet logging all activity events Brief user instructions sheet on how to use the logger. Skills Required Excel VBA / Macros PivotTables and Charts Experience with live timers in Excel Estimated Effort 3–5 hours for a competent VBA developer. Should be delivered fully functional and tested.

URGENT: Senior Excel Dashboard Specialist

I require an experienced Excel dashboard specialist to convert existing Excel data into two fully interactive, visually appealing dashboards, suitable for director-level reporting and PDF export. All data already exists in Excel. The task is to design, link, and automate dashboards so that KPIs, charts, and summaries update dynamically based on filters. This work must be completed today (within 12 hours). Scope of Work 1. Project-Specific Dashboard (A4 – Print Ready) One dashboard per project (template-based, scalable) Header to dynamically display: Project name Reporting period / week Fully interactive filters: Project Week number Trade Labour category (if applicable) Required KPIs (all must update with filters): Total hours worked Hours by trade % labour distribution by trade Weekly hours comparison Any cost or productivity KPIs already present in the data Charts & Visuals: 2 summary charts, e.g.: Labour hours by trade Weekly labour spread Clean, professional layout (improve existing design) Visually appealing but suitable for senior management Output: A4 layout Button to export dashboard directly to PDF Suitable for filing as part of a project history record 2. Labour Overview Dashboard – All Projects High-level dashboard covering all jobs Focus on: What was worked on in a given week (e.g. Week 2) Distribution of labour hours across projects Trade-level labour spread Interactive slicers to allow directors to: Change week Filter by project Filter by trade Key Requirements: All KPIs and charts respond instantly to filter changes Clear overview of where labour hours are being spent Designed for decision-making and trend analysis Technical Requirements Excel (no Power BI) Use of: Pivot tables / pivot charts Slicers / timelines Dynamic formulas where required Dashboard must be: Stable Easy to update with new data Scalable for future projects One-click “Export to PDF” button (VBA acceptable) Key Goals (Non-Negotiable) All KPIs must move when filters change Interactive and visually polished Director-ready reporting Printable to PDF Delivered within 12 hours What I Will Provide Excel file with all source data Screenshot / example of the intended layout Clarification on KPIs if needed (but freelancer should be able to interpret data structure independently) Ideal Freelancer Advanced Excel dashboard developer Strong design sense (not just technical) Experience creating print-ready dashboards Comfortable working under tight deadlines

opportunity

Excel Expert + Marketing Analyst (Data Insights)

We are looking for an experienced Excel power user with a strong marketing analytics background to turn a raw marketing dataset into clear, actionable insights and a leadership-ready action plan. What you’ll do: • Take our provided dataset (CSV/Excel format – details shared upon hiring) containing marketing performance data (campaign results, customer behavior, channel spend, conversions, etc.) • Clean, structure, and deeply analyze the data using advanced Excel techniques • Uncover key insights (e.g., ROI by channel/campaign, customer segmentation trends, high-performing creatives/audiences, bottlenecks, growth opportunities) • Build clear, professional dashboards and visualizations (charts, pivot tables, conditional formatting, slicers – all native Excel, no Power BI required) • Deliver a concise executive presentation (5–10 pages/slides in Excel or PDF) that includes: • Top 5–8 actionable insights • Prioritized recommendations with estimated impact • Clear next-step action plan for the leadership team • Supporting data visuals that non-technical executives can understand immediately Required skills & experience: • Advanced Excel mastery (PivotTables, Power Query, advanced formulas, Index/Match, dynamic arrays, VBA/macros strongly preferred) • Proven marketing analytics experience (you must have worked with campaign performance, customer LTV, funnel analysis, attribution, or similar) • Ability to translate numbers into business stories and recommendations • Experience creating board/leadership-level reports or presentations • Excellent attention to detail and data accuracy

opportunity

Microsoft Access Developer (Azure SQL Back-End)

We require a Microsoft Access developer to create a robust customer and call management system for our company. The system will: Import weekly CRM and Waiver CSVs Deduplicate bookings and merge records Calculate 12-month spend and visits Generate automated call lists for several sales campaigns (party reactivation, birthdays, upsells, etc.) Provide two user levels (Manager / Staff) with dedicated dashboards, data correction tools, and KPI reporting. The database back-end will be hosted on Azure SQL Database with Azure AD authentication (IT team will provide). You’ll build the Access front-end (forms, queries, VBA automation) and ensure clean integration. Experience in Access-to-SQL linking, VBA ETL routines, and user interface design is required.

opportunity

Excel Logistics Model Optimization & Data Cube Integration

I have a partially built Excel-based logistics planning model used by our logistics team for weekly operations. The file is growing in size (~10MB) and needs optimization and scaling. I'm looking for an Excel expert to: a) Workbook Scaling & Formula Optimization - Expand the model to cover a full year of weekly sheets (currently only a quarter built) - Review and refine formula logic, especially around summing logic but possibly data validation and conditional formatting if deemed necessary. - Resolve issues with duplicated defined names when copying weekly sheets if appearing - Explore grouping/minimizing vehicle rows by Vehicle_Grp for better usability across site users. b) Stock Sheet Review - Audit the use of INDIRECT functions across depot stock sheets to sum the weekly sheets efficiently - Assess and improve grouping logic for SKUs and weekly data c) Driver-Friendly Printouts - Create a user-friendly way to print a vehicle’s job list by selecting week/day/vehicle - Ignore blank lines and return only active entries. - Potentially generate a weekly driver summary by name, if possible. d) Data Cube Integration - Extract and structure all relevant input data into a Power Pivot or Power Query data model (data cube/db) - Enable trend analysis by customer, location, and collection frequency Ideal Skills: - Advanced Excel (Power Query, Power Pivot, VBA optional) - Experience with logistics or operations models - Strong understanding of workbook performance optimization Looking to start immediately. Budget type negotiable

opportunityurgent

Excel Booking System & Linked Sales/Purchases Log

About us We’re a small Belfast-based golf tour operator. We’re looking for an Excel specialist to finish and refine our booking workflow so it’s robust, attractive, and easy for our team to use. What we need A complete, user-friendly Excel solution comprising: Customer Booking Form (Excel) Branded layout, clean typography, and clear green accents suitable for a golf brand. Save / Submit button that: Appends each booking to a Master Sales table. Resets the form to a fresh, blank state for the next entry. Validated fields with dropdowns for courses, hotels, transfers, suppliers, clusters, etc. (we have the lists and must be able to add to them over time). Sensible defaults, clear messages, and protection so only intended input cells can be edited. Linked Sales & Purchases Logs (already started) Finalise and harden formulas/queries to keep: Master Sales (Booking Ref, Lead Name, PAX, Tour, Date Travelling, Invoice Amount, Deposit Paid, Payment Method, Total Paid, Outstanding Balance, Date Balance Due/Paid, Total Costs, Costs Paid, Outstanding Costs, Profit, Notes) Master Purchases (Booking Ref, Vendor, Category, Tour, Service Required, Cost, VAT Rate, VAT Amount, Gross, Date Confirmed/Playing, Deposit/Balance, Payment Method, Date Costs Due/Paid, Lead Name, Date of Travel, PAX) auto-updating without copy/paste (Power Query or VBA where appropriate). Summary / Performance Dashboard (KPI-driven) A polished summary sheet with slicers/filters (Date, Tour, Category, Supplier, Status) and visuals for the KPIs our files already track: Sales & Profitability Total Bookings Total PAX Revenue (sum of Invoice Amount) Deposits Received Total Paid Outstanding Balance Total Costs Costs Paid Outstanding Costs Gross Profit (£) Profit Margin % Revenue / PAX, Cost / PAX, Profit / PAX Operations & Pipeline Upcoming Departures (next 7 / 30 / 60 days) Balances Due Soon (by due date bucket) Payment Status (Paid / Deposit Only / Balance Outstanding) Suppliers & Products Spend by Category (Course, Hotel, Transfers, Extras, Other) Top Suppliers by Spend Top Tours / Packages by Revenue & Margin Compliance / Tax (as applicable) TOMS VAT: show default rate and fraction from Settings, and basic VAT aggregates from Purchases (VAT Rate/Amount/Gross). Automation & Structure A tidy folder that “just works” (e.g., \Booking Form, \Data (Master Sales/Purchases), \Reports). Buttons/macros for Save Booking, Refresh Data, Add List Item, Open Dashboard. Power Query and/or VBA so links refresh reliably with one click. Protection & Reliability Lock formulas and structure; keep inputs open. Clear error handling (missing mandatory fields, invalid dates/amounts). Unique Booking Ref logic to prevent duplicates. Current status We have functioning workbooks and dropdown lists (e.g., Courses/Hotels/Transfers and clusters), a Booking Financials form with fields such as PAX, Total Invoice Amount, Deposit, Balance, Income/Outgoings per Person, and Profit per Person, plus Master Sales and Master Purchases tables with the columns listed above. We need a pro to finish the linking, fix/confirm formulas, set up the save/reset routine, and polish the design and protection. Deliverables Final Excel set: Booking Form, Master Sales, Master Purchases, Summary Dashboard. Working Save/Submit flow (logs booking → refreshes logs/dashboard → resets form). Auto-updating queries (no manual copy/paste). Protected formulas; guided inputs; easy list maintenance for dropdowns. Branded, clean visuals using 18Ireland styling (greens, subtle greys, readable fonts). A short illustrated How-To (1–3 pages). Optional: quick handover call/screen share. Must-have skills Advanced Excel (structured tables, data validation, named ranges). Strong formulas (SUMIFS, INDEX/XMATCH, LET/LAMBDA where helpful). VBA for user-friendly buttons and controlled save/reset routines (or low-code alternatives). Power Query (Get & Transform) for reliable updates across linked files. Protection best practices. Nice to have Power Pivot / basic data modelling for scalable summaries. UX polish for clear, attractive dashboards. Travel/booking workflow experience. Success criteria Staff can add a booking, click Save, and: Entry is stored in Master Sales (unique Booking Ref). Master Purchases and the dashboard update on refresh. The form resets cleanly for the next customer. Users can add new dropdown items without breaking validation. Key sheets are protected; inputs are obvious and easy. Files sit in a logical, documented folder and are robust for regular updates. Budget & timing Please propose a fixed price or a clear estimate with milestones. We’re ready to proceed. To apply, please include: Your approach (VBA vs Power Query mix, logging method, protection strategy). 2–3 examples of similar Excel/VBA/Power Query projects. A brief timeline and cost. Any suggestions to improve robustness or usability.

opportunity

Excel Dashboard Developer – Performance Tracker

Project Overview: I’m looking for an experienced Excel specialist to build an automated performance dashboard for my estate agency group. We have six Sales offices and six Lettings offices, and I want to track daily performance metrics from two data sources: 1. Call logs (exported from our phone system) 2. Reapit CRM reports (valuations, viewings, instructions, offers, sales agreed, exchanges, etc.) The aim is to have one Excel workbook that I can easily update each day by pasting in new data or refreshing Power Query connections. The dashboard should automatically show: • Individual Negotiator activity (calls, talk time, performance vs target) • Office-level summaries for each of the 12 branches • Department-level views (combined Sales and Lettings totals) • A simple front page with clear charts, slicers (Office / Negotiator / Date), and key KPIs. ⸻ What I Need: • Build an Excel-based dashboard with dynamic visuals and KPIs • Automate data refresh (via Power Query or macros) • Create clean dashboards for: • Individual negotiators • Each office (6 Sales, 6 Lettings) • Department summaries (Sales & Lettings) • Use a clean blue and white theme with easy navigation • Include a short guide or Loom video showing how to update the data daily ⸻ Skills Required: • Advanced Excel (Power Query, PivotTables, Dashboard Design) • Strong visual layout and performance reporting experience • Familiar with CRM or sales data structures (Reapit experience a plus) • VBA experience (nice to have but not essential)

I am looking for an Excel programmer

The Excel sheet must have the following: Everything outside the yellow areas and the images are untouchable, and the images must be fixed. Do not break the existing formats. Only one payment option should be selectable (PayPal, Wire Transfer, Check, Zelle). After one option is chosen, the others should be deactivated. The user must clear their current selection to choose a different method. a. Face (Same Method): Only one thickness option should be selectable (e.g., 1/8’’ or 3/16’’). b. Upper Box (Same Method) c. Box Depth (Same Method) Acceptance of Terms and Conditions Before selecting a payment option, users must be required to check this box: "I accept the Terms and Conditions." This verification must be mandatory (e.g., enforced via Data Validation or VBA). The customer should be able to email their quote from the product selection page to us with a single button click. Note: Please let me know if you have any recommendations.

VBA expert required to fix a print subroutine

I believe this is a very quick job for a real VBA expert. I am attaching: 1) A two page pdf of the output from a macro I have been writing. 2) The VBA PrintSub routine The macro prints a number of vouchers (two columns x five rows) up to a maximum of 20. The issue is that the two images (logo and QR code) in the voucher appear to move vertically down over the course of the printing. Please look at first row on Page 1 and then the last row on Page 2, I believe the reason is that they are not fixed correctly to the voucher in the print subroutine. In simple terms the code creates a single voucher and fixes the images in that voucher, and then repeats the print across and down the page(s). I am an amateur code writer and not particularly elegant in my code. I am fairly sure that the issue has to do with the point in the code where I am fixing the image files. I do believe that this needs a real expert who understands the subtleties of creating print outputs I am not asking anyone to fix this before accepting the project, but I just want you to be absolutely sure you know you can. Please start your message with the sum of 69 and 31 Thank you Chris

VBA script from excel to test and configure MySQL connection

The description provided is as follows: "I am looking for a freelancer to help me with a project. The project involves writing a VBA script in Excel to test and configure a MySQL connection. The script should check the connection, configuration, and drivers for MySQL and ensure that the connection can be opened and established for the export of data from Excel. The freelancer will also need to remote into my laptop via AnyDesk or TeamViewer to make any adjustments or configuration. If you have experience with Excel macros and MySQL, please apply for this project."

Excel spreadsheet alterations

This project involves enhancing an Excel workbook used to track finances for a football club. The existing workbook contains multiple spreadsheet tabs, one for each team, with a running monthly total displayed at the top of each sheet. However, the number of rows available for inputting individual bank transaction details is limited. The goal of this project is to modify the workbook's structure to allow efficient entry and tracking of all expected financial transactions through next year. Some potential solutions include inserting additional rows on each tab, converting to a more flexible layout, or developing VBA macros to dynamically generate rows as needed. The ideal candidate will have strong Excel skills including functions like SUMIFS and experience working with multiple related sheets. They should propose an optimized design that maintains existing functionality while future-proofing against data volume growth. clarity and documentation of any changes made will be appreciated. The final deliverable is an updated Excel file with an improved system for comprehensive recording of bank activity for each team over the next 12 months.

Export data from excel to MySQL

An experienced programmer is sought to build a Visual Basic for Applications script automating data exports from Excel to MySQL. The workbook houses two crucial worksheets - a primary sheet containing nearly nine-hundred-thousand information records, and a secondary with seventeen-thousand supplementary rows. The script must extract all records from the primary sheet into corresponding MySQL tables, incorporating logic to detect duplicate entries based on identifying columns to prevent redundant uploads. It also needs periodic execution capability to seamlessly transfer newer additions from the secondary seventeen-thousand row sheet. Proficiency in VBA, MySQL and handling large datasets is required to efficiently update records without duplication. Only candidates demonstrating proven experience delivering precisely what is outlined here should apply.

Excel Automation Expert to configure data

This is a very simple task, shouldn't take to long to do. I need an Excel expert to configure an automatically updating transaction statement in my spreadsheet. The spreadsheet contains two sheets: Sales and Expenses. I want a third sheet called Transaction Statement to pull and combine data from both, updating itself when I add new entries. Scope of Work: 1. Extract from Sales Sheet: Columns needed: DATE PAID, CUSTOMER NAME, and TOTAL AMOUNT. Map to: Date → DATE PAID Name → CUSTOMER NAME Incoming (£) → TOTAL AMOUNT Outgoing (£) → Leave as 0 2. Extract from Expenses Sheet: Columns needed: DATE PAID, SUPPLIER NAME, and TOTAL AMOUNT. Map to: Date → DATE PAID Name → SUPPLIER NAME Outgoing (£) → TOTAL AMOUNT Incoming (£) → Leave as 0 3. Create Transaction Statement Sheet: Combine both data sets into a single sheet. Sort the data by Date (like a bank statement). Ensure the sheet updates automatically when new rows are added to either the Sales or Expenses sheet. 4. Automation Options (any of the following): Power Query (preferred if no macros needed) VBA Script/Macro (if Power Query is not suitable) Any other seamless Excel solution

Expert Needed for Data Scraping & Lead Generation Automation

I’m looking for an expert in data scraping and automation to help set up a system for generating high-quality leads from websites such as LinkedIn, Indeed, and other relevant platforms. The ideal candidate will have: • Strong experience in developing web scraping and API scraping tools • Advanced skills in Python, VBA, including the ability to send and receive data through APIs • A solid understanding of lead generation workflows • The ability to advise on best practices and help shape the structure of the project • Experience with scraping or integrating with platforms like LinkedIn, Twitter, Indeed, etc. This is a project with room for growth and automation. I’m ready to get started immediately and would appreciate guidance on how best to set this up for ongoing use. Please share details of your experience, examples of similar projects, and your availability. I’m happy to schedule a call to discuss the scope and your ideas. Looking forward to working with you, Mohamad