Visual Basic Jobs

I have an existing workbook that’s crying out for full automation. Everything the file does now—data crunching, formatting, report prep—needs to run end-to-end the moment the file opens, with zero user input. No web scrapes or database calls are involved; every source the macros need is already inside the workbook or on additional sheets I will supply. Here’s what I expect from you: • A clean, well-structured VBA module (or modules) that handles the entire workflow automatically on Workbook_Open or a similar event. • Solid error handling so the process can finish—or exit gracefully—without pausing for prompts. • Clear in-code comments plus a brief hand-over note so I can maintain or extend the macros later. If you can jump in imm...

I’m looking for a well-structured action-tracking file (in excel preferred) that can live at the centre of our non-conformity and engineering-change request workflows while still handling the odd small project or personal to-do list. Key elements I must see: • Sections that behave like independent workstreams. • Inside each section, tasks and nested sub-tasks carrying these fields: Title, Notes, Priority, Responsible Department(s), Start Date and End Date. • A live Gantt view where every task and sub-task automatically shades its scheduled timeframe. • Conditional formatting so anything that rolls past its End Date without a “completed” flag lights up red. • A front-page dashboard that pulls status counts, late items, and upcoming deadlin...

I need to import data from an Excel spreadsheet with multiple sheets into a data range using Power Query. The sheets have different structures and contain mixed data types. Requirements: - Use Power Query to import data - Handle multiple sheets with varying structures - Support for mixed data types (text, numeric, etc.) Ideal Skills: - Proficiency in Power Query - Strong Excel skills - Experience with data transformation and import tasks Please share your experience and approach.

Looking for a senior Excel VBA developer to automate a recurring Timesheet/ Finance Excel workflow. The automation will process multiple Excel forecast templates stored in SharePoint, paste monthly timesheet data, update period controls, and run review-only validation checks. No live or confidential data will be shared — dummy data only.

I’m working with several Excel workbooks that hold mixed data—text, numbers, the occasional date—and they all need to look the same before I can move on to analysis. I’d like you to combine careful data entry with a bit of smart coding to make that happen. Here’s the flow I have in mind: • Start by reviewing the current Excel sheets, noting the varied column orders, inconsistent headings, and scattered blank cells. • Build a small, reusable script or macro—Python with pandas / open, or native Excel VBA, whichever you prefer—that: – re-orders and renames columns to match my template, – normalises number, text, and date formats, – removes or clearly flags empty or duplicate rows, – outputs a singl...

I’m working with several Excel workbooks that hold mixed data—text, numbers, the occasional date—and they all need to look the same before I can move on to analysis. I’d like you to combine careful data entry with a bit of smart coding to make that happen. Here’s the flow I have in mind: • Start by reviewing the current Excel sheets, noting the varied column orders, inconsistent headings, and scattered blank cells. • Build a small, reusable script or macro—Python with pandas / open, or native Excel VBA, whichever you prefer—that: – re-orders and renames columns to match my template, – normalises number, text, and date formats, – removes or clearly flags empty or duplicate rows, – outputs a singl...

Project Title: AI Chatbot Platform for Bank-Ready Project Reports, Financial Viability & MSME Funding Project Description: We are developing an AI-powered chatbot / SaaS platform that can understand business projects in depth and automatically generate detailed, bank-acceptable project reports (DPRs) for Startups, MSMEs, and Enterprises. The system must combine AI intelligence with structured financial logic, include a Chartered Accountant (CA) vetting workflow, and align outputs with Indian banking, NBFC, and financial institution standards. This is a serious, long-term product build, not a basic chatbot. ⸻ Scope of Work (Phase 1 & 2): 1. AI Chatbot & Project Understanding • Conversational AI to collect and understand: • Business model, promoters, industry,...

I have a collection of customer records sitting in plain text documents and I want every single detail moved into a clean, structured spreadsheet. The job is pure data entry—no analysis, no guessing—just accurate transcription of names, contact details, and any other fields that appear in the files. You can work in Excel, Google Sheets, or another format we agree on, as long as the final file is ready for easy sorting and filtering. Consistency, correct spelling, and respect for data-privacy are critical; I will provide a short style guide so we enter each field the same way every time. Deliverables • A complete spreadsheet (Excel / Google Sheets / CSV) containing every customer record found in the supplied text documents • A brief log noting any illegible entri...

Across several ongoing spreadsheets I have, the data is only partially organized and now needs to move to the next level—full automation through well-built macros. The immediate goal is to eliminate repetitive actions and speed up my workflow by embedding reliable VBA code directly into each workbook. Although I will share the exact files and logic with you once we begin, expect the work to revolve around tasks such as streamlining data entry, generating recurring reports, and tidying raw sheets into analysis-ready tables. If you can turn those manual clicks into a single button press, you are the right fit. Deliverables (per workbook) • Clean, commented VBA modules tailored to my existing sheet structure • Any helper functions or user-forms necessary for a seamless u...

Across several ongoing spreadsheets I have, the data is only partially organized and now needs to move to the next level—full automation through well-built macros. The immediate goal is to eliminate repetitive actions and speed up my workflow by embedding reliable VBA code directly into each workbook. Although I will share the exact files and logic with you once we begin, expect the work to revolve around tasks such as streamlining data entry, generating recurring reports, and tidying raw sheets into analysis-ready tables. If you can turn those manual clicks into a single button press, you are the right fit. Deliverables (per workbook) • Clean, commented VBA modules tailored to my existing sheet structure • Any helper functions or user-forms necessary for a seamless u...

I keep a master Excel list of participants and would like the entire communication cycle to run itself—from pulling data in that workbook, to drafting and sending Outlook emails, and finally issuing timed reminders until each recipient completes a required action. Here is the flow I want scripted: Excel should supply names, addresses, and any other fields I flag. Outlook then builds an email for each row, inserting the fields into the subject and body. Once the first wave goes out, a reminder sequence kicks in automatically: if someone has not replied / clicked a link / changed a status cell in the sheet, Outlook (or a Power Automate flow, if you prefer) sends follow-ups on a schedule I can modify—daily, weekly, or monthly. Key points to cover • One-click or schedu...

Several spreadsheets land in my inbox every week and I need them meticulously entered, cleaned, and combined into a single reliable source of truth. The job is entirely data-focused: you’ll take raw files, input missing records, correct inconsistencies, and merge everything into a master dataset that I can reference at any time. You may work in Microsoft Excel, Google Sheets, or another database tool you prefer—the key is accuracy, speed, and a clear audit trail of any changes you make. If formulas, pivot tables, or basic scripts help streamline the workflow, feel free to use them; just document what you’ve done so I can follow along later. Deliverables: • Fully updated and consolidated master file (Excel or Sheets format) • A brief change log noting additions...

I need someone who lives and breathes Excel to tackle a non-finance dataset for me. The goal is twofold: first, turn raw information into clear, insightful visual summaries (think dynamic charts, slicer-driven dashboards, conditional formatting—whatever best tells the story); second, run a solid regression analysis so I can understand which variables truly drive the outcome I care about. To prove you can handle the job, attach an Excel workbook you built yourself. It should showcase both your visualization style and any analytical techniques—complex formulas, pivot tables, Power Query steps, maybe a VBA snippet if it adds value. Bids that arrive without this sample file won’t be considered. If we work together, I’ll send the cleaned data and a short brief on the q...

I need a custom search box in Excel specifically designed to filter bank statement data. Requirements: - Functionality: Simple text search - Data Type: Text (bank statement data) - Single Sheet: Search box should operate on one sheet only Ideal Skills and Experience: - Proficiency in Excel, including data filtering and search box creation - Experience with designing user-friendly interfaces within Excel - Attention to detail to ensure accurate data retrieval Looking for a freelancer who can deliver a functional and easy-to-use search box tailored to my needs.

I need a custom search box in Excel specifically designed to filter bank statement data. Requirements: - Functionality: Simple text search - Data Type: Text (bank statement data) - Single Sheet: Search box should operate on one sheet only Ideal Skills and Experience: - Proficiency in Excel, including data filtering and search box creation - Experience with designing user-friendly interfaces within Excel - Attention to detail to ensure accurate data retrieval Looking for a freelancer who can deliver a functional and easy-to-use search box tailored to my needs.

I need one or more Excel-based project management templates that I can drop straight into my daily workflow. The focus is on clean, reusable layouts that rely only on basic formulas and functions—think SUM, IF, conditional formatting, simple date math—so anyone on the team can follow what’s happening without touching VBA, macros, or pivot tables. The end result should make it effortless to plan tasks, track progress, monitor deadlines, and see at a glance where a project stands. A clear, logical sheet structure and good cell protection rules are just as important to me as the formulas themselves, because these files will be shared widely. Deliverables • An unlocked master template and a protected “ready-to-use” version • Brief in-sheet notes or a...

I need an Excel workbook that can price every listed F&O option—both equities and indices—in a single sweep. The model must pull stock price, strike, risk-free rate, time to maturity, and volatility automatically through an external data source or API, then run the Black-Scholes formula and return the option price along with delta and gamma for each contract. You’re free to use native formulas, VBA, Office Scripts, or a combination, as long as the sheet stays responsive when thousands of rows refresh. A refresh button that triggers the API call and recalculates all results would be ideal. Deliverables: • Fully-functional Excel file with embedded or linked code • Clear setup notes covering any API keys, data-mapping, and update frequency • A short ...

I need a clean, reliable Excel workbook that fully automates the Black-Scholes model for European options. The sheet has to cover three core tasks: • Pricing European calls and puts through the classic Black-Scholes closed-form equation • Calculating the main Greeks (Delta, Gamma, Theta, Vega, Rho) in real time • Back-solving for implied volatility from a market option price Inputs should be limited to the standard five variables—stock price, strike price, time to maturity, risk-free rate, and volatility—entered in clearly labeled cells so anyone can run scenarios instantly. No charts or visualizations are required; results can remain in tabular form. Accuracy is critical: outputs must match authoritative benchmarks to at least four decimal places, and ...

For my small shop I want a straightforward Excel workbook that lets me enter sales and expenses each day and immediately see the totals and daily profit-and-loss. The sheet should be laid out so I can record every sale in one table and every expense in another; the moment a line is added the automatic formulas must refresh the running totals and the day’s P&L figure without extra clicks. I update the file every evening, so speed and simplicity matter more than elaborate dashboards. A clean interface, clear input fields, and well-labeled formulas will be appreciated. I do not need inventory management at this stage—only sales recording and expense tracking with the relevant calculations already built in. Deliverable: • A ready-to-use Excel workbook (.xlsx) contain...

I manage several spreadsheets every week and the manual copying, cleaning, and summarising is chewing up far too much time. My objective is to fold the entire workflow—data import, transformation, and final reporting—into a single, well-structured workbook driven by VBA. just simple task 2-3 hrs max

I need an Excel sheet that automatically calculates and updates the RSI (Relative Strength Index) for multiple time frames: 1H, 4H, Daily, Weekly, and Monthly. This will be sourced from my BArchart subscription. Requirements: - Use of BArchart API for real-time data - Excel sheet with automated RSI calculations - Real-time updates are essential Ideal Skills and Experience: - Proficiency in Excel, particularly with API integration - Experience with financial data and technical indicators - Familiarity with BArchart and its API would be a plus

I already have a working VB.NET source that drives a POS thermal printer; it reliably sends bills and invoices to the device, but the visual structure needs polishing. I want the header and footer rearranged so the logo area, tax info, and thank-you note sit neatly without wasting paper; the itemized list should line up perfectly in clean columns; and every block of text—totals, discounts, date, and cashier details—must be consistently aligned. You’ll receive sample printouts that show the look I’m aiming for, plus the current solution so you can see how things are wired. Once your changes compile and the output on paper matches the examples, the job is done and we can move on to the next set of enhancements I have queued. VB.NET experience with ESC/POS or simila...

I need a series of existing Word documents converted into a single, well-structured Excel workbook that people can fill in quickly without breaking the layout. The source files mix text fields, numeric inputs, and date entries, so every sheet you build must handle those three data types cleanly with proper data validation where it helps. The workbook should be organised as multiple sheets, matching the logical sections of the Word docs. I also want a handful of simple formulas—think subtotals, averages, and automatic date-difference calculations—so users see key figures update the moment they enter data. Nothing advanced like macros is required, but clear cell protection, tab naming that mirrors the document headings, and professionally formatted tables are important for usabi...

Objective: Automate the process of converting exported quote data from our sales/CRM system into a standardized Excel layout for creating showroom price lists. Current Situation: We export quotes from our CRM in a consistent format (XL, CSV, or PDF). The target layout for the price list is always the same in structure but must dynamically adjust in length based on the number of items in the export. Currently, this formatting is done manually, which is time-consuming. Requirements: Develop a solution (Excel macro, VBA script, or small program) that: Imports the exported data (CSV or Excel preferred). Re-formats it into the predefined layout automatically. Adjusts the layout dynamically based on the dataset size. Allows customisation of visual elements, including borders, background colo...

I run a small business that collects printed receipts every day. I’ve already created a shared Google Sheets file; what I need is a reliable hand to keep it up-to-date with the data on those receipts. Scope • Input every receipt from the current batch and any new ones I upload. • Record only the number of items sold on each receipt (no revenue figures or payment methods for now). • Maintain the existing column order, data validation, and simple SUM formulas that total the daily item count. • Flag any illegible or duplicate receipts in a separate “Issues” tab so I can check them quickly. Deliverable A neatly updated Google Sheets workbook that reflects 100 % of the receipts I provide, with all item-count totals matching the physical slips. ...

I have a CSV that contains Column A plus another three to five accompanying columns. Every value in Column A needs an “@” prefixed to it. (at the front) Once that’s done, the entire sheet must be re-sorted so that the shortest text in Column A appears first and the longest last. Please keep all other columns perfectly aligned with their corresponding rows during the sort. PLEASE REMOVE DUPLICATES. Would be grateful if someone can finish in less than a day for a tip. For someone who knows excel you can probably do this in 3 Additional notes: • Several columns include special characters, so please leave those untouched. • While you work, remove any duplicate rows that may exist after the “@” is added. Deliverable: a single, cleaned CSV re...

I'm seeking an experienced VBA developer to automate several tasks in Excel. Key Tasks: - Automate data entry processes to minimize manual input. - Streamline data analysis and reporting tasks. - Generate charts and graphs automatically from data. Integration: - Must integrate with other Excel files. Ideal Skills and Experience: - Proficiency in VBA programming. - Strong Excel skills, including advanced functions. - Experience with data automation and integration. - Ability to deliver clean, efficient, and well-documented code. - Attention to detail and problem-solving skills. Please provide examples of previous relevant work.

I have a single hiring tracker in Excel (about 47 rows) that has grown messy after several quarters of inconsistent updates. The immediate priority is to turn this file into a clean, analysis-ready dataset: • Audit the whole sheet, flag and correct data-type mismatches, duplicate or missing values, and any inconsistent naming conventions. • Re-structure columns so dates, candidate details, and hiring-stage fields use one uniform format throughout. If you spot a better field layout, propose it before implementing. • Apply light, intuitive formatting—filters, conditional highlights, and a tidy header row—so anyone can scan the sheet and understand status at a glance. Once the tracker is spotless, I need a succinct analysis that surfaces actionable insights. T...

I have a single hiring tracker in Excel (about 47 rows) that has grown messy after several quarters of inconsistent updates. The immediate priority is to turn this file into a clean, analysis-ready dataset: • Audit the whole sheet, flag and correct data-type mismatches, duplicate or missing values, and any inconsistent naming conventions. • Re-structure columns so dates, candidate details, and hiring-stage fields use one uniform format throughout. If you spot a better field layout, propose it before implementing. • Apply light, intuitive formatting—filters, conditional highlights, and a tidy header row—so anyone can scan the sheet and understand status at a glance. Once the tracker is spotless, I need a succinct analysis that surfaces actionable insights. T...

I have a steady stream of PDFs and scanned images that contain mixed text and numerical information. Your task is to lift every value from those files and place it into an Excel workbook or Google Sheet with absolute precision. Accuracy is the priority—any typo or misplaced number could break later analysis, so I’ll be checking for 100 % exact matches against the source. Key formatting requirement • Column alignment (no extra styling or color coding needed) What you’ll deliver • A clean, fully-populated spreadsheet in the platform of my choice (Excel or Google Sheets) • A short note highlighting any ambiguous entries you ran into The workload comes in batches, so if we work well together there’s ongoing work waiting. When you reply, let me kn...

I have a single hiring tracker in Excel (about 47 rows) that has grown messy after several quarters of inconsistent updates. The immediate priority is to turn this file into a clean, analysis-ready dataset: • Audit the whole sheet, flag and correct data-type mismatches, duplicate or missing values, and any inconsistent naming conventions. • Re-structure columns so dates, candidate details, and hiring-stage fields use one uniform format throughout. If you spot a better field layout, propose it before implementing. • Apply light, intuitive formatting—filters, conditional highlights, and a tidy header row—so anyone can scan the sheet and understand status at a glance. Once the tracker is spotless, I need a succinct analysis that surfaces actionable insights. T...

I need a simple, low-cost way to pull thoroughbred racing form the official racing website and drop it straight into my existing Excel template whenever I choose. The process must run on an ordinary New Zealand Windows laptop—no paid cloud services, no expensive subscriptions—as long as I can launch it with a click. We will only work with the API available, as scrapping is not allowed by the sites Terms and Conditions. Core requirements • Source: only the official racing website I will specify. • Output: a fully populated Excel workbook that keeps my current column structure. - Calculations: needs to include specific calculations in the Excel workbook as per my attached Project Description • Data points: everything listed in the attached Project Description with...

I'm looking for a skilled freelancer to create a simple macro for LibreOffice Writer that can transform text formatting. The macro should be able to: - Change style of certain given texts - Adjust paragraph alignment - Create a two-column, one-row table and moving text in it Ideal Skills and Experience: - Proficiency in LibreOffice Writer - Experience with macro development - Understanding of text formatting and table creation I will send you a text with the precises insztructions

Requirement: Excel Expert to Build a Costing & Wastage Calculation Software I am looking for an Excel master / advanced Excel developer who can create a complete costing software in Excel. The tool should be clean, automated, user-friendly, and suitable for daily business use. Project Scope I need an Excel-based system that can handle: Material costing Quantity-based cost calculations Automatic wastage % and wastage cost Total cost per item Summary dashboard Editable data tables Auto-calculation using formulas or VBA Easy UI for non-technical users Optional (If you can provide): Dropdown selections Protected sheets with editable fields Macros/VBA for automation Multi-sheet system (Raw Material, Costing, Summary, Quotation) PDF export for costing sheets Deliverables ...

I am looking for someone to finish building a polished, self-contained Excel dashboard using freely available government data. Project Scope I need an Excel expert who can take publicly accessible datasets and turn them into a clean, interactive dashboard that demonstrates strong skills with: Pivot tables Pivot charts Named ranges Slicers Conditional formatting Other interactive Excel features What I need you to complete: • Identify reliable public datasets (e.g., Bureau of Labor Statistics, FRED, World Bank, or other government sources). • Import, clean, and organize the data in Excel, using structured tables and named ranges so refresh works smoothly. • Create a backend worksheet containing all pivot tables and calculations. • Build a professional dashboard s...

I have several thousand voter-list PDFs written entirely in Marathi. I need a reliable workflow—script, desktop utility, or small web app—that will scan every page, recognise the Marathi text correctly, and export each voter’s details to an Excel spreadsheet. The fields I must see in separate columns are: • Name and address • Voter ID / EPIC number with any contact details that appear • Date of birth and gender • Age Accuracy is critical; diacritics and vowel signs in Marathi must not be lost or misread. I will provide sample PDFs so you can tune your OCR or pattern-matching logic. The final deliverable is: 1. An Excel file containing every voter record, perfectly aligned to the columns above. 2. The complete, well-commented source code or...

We maintain a library of Microsoft Word templates powered by VBA macros and a couple of custom add-ins. Lately the functionality has started to break down—macros fail partway through their routines. With the new Office 365 upgrade, they are blocked from running. I have attached the files. The whole suite includes several macros, 7 templates and a customized tool bar ribbon. Here’s what I need: • Audit and repair the current templates so they run. • Identify bugs in these macros and identify what needs to be fixed. This job is complete when I can run the macros on my system. But, I will probably want to do a phase 2 that is more extensive to fix the bugs you identified and to complete some other macros. Requirements: -comfortable with VBA, Word object m...

I maintain a library of Microsoft Word templates powered by VBA macros and a couple of custom add-ins. Lately the functionality has started to break down—macros fail partway through their routines and the add-ins no longer hook into the templates the way they once did. Here’s what I need: • Audit and repair the current templates so every macro runs end-to-end without errors. • Debug the add-ins so they load reliably and perform their assigned tasks inside Word. • Debug the ribbon menu A job is complete when each macro runs correctly, and every macro or add-in feature can be clicked through without throwing an error or disabling itself. I work in the latest Microsoft 365 environment, so please be comfortable with VBA, Word object model, and any tooling...

I need a straightforward system that lets me record every household purchase the moment it happens, then shows at a glance how those daily costs add up across the month. The goal is simple: keep my routine spending in check so nothing slips through the cracks. I’m only tracking household expenses—groceries, utilities, rent, maintenance and anything else that keeps the home running. Business or personal-luxury costs sit outside the scope, so the workflow should filter those out automatically. A clean Google Sheets or Excel workbook is fine, but if you can suggest a lightweight app or dashboard that syncs easily with my phone, I’m open to it as long as the data stays exportable. What matters is: • quick daily entry (ideally under a minute) • clear weekly...

I need a single-workbook Excel solution that lets our in-house print team generate accurate job quotes in minutes. The sheet has to capture every major cost driver—material, labour and overhead—then roll them into a clean “Total Cost” and suggested selling price. Pricing figures will be entered manually, but I want smart alerts that prompt us when any input is older than a preset number of days so our numbers never go stale. Conditional formatting or a lightweight VBA routine is fine, as long as it’s easy for non-technical staff to update the cell values themselves. Core flow I’m picturing: • User selects or types project specs. • Workbook pulls the current material, labour and overhead rates from a dedicated “Price Table” tab. ...

I have a single hiring tracker in Excel (about 47 rows) that has grown messy after several quarters of inconsistent updates. The immediate priority is to turn this file into a clean, analysis-ready dataset: • Audit the whole sheet, flag and correct data-type mismatches, duplicate or missing values, and any inconsistent naming conventions. • Re-structure columns so dates, candidate details, and hiring-stage fields use one uniform format throughout. If you spot a better field layout, propose it before implementing. • Apply light, intuitive formatting—filters, conditional highlights, and a tidy header row—so anyone can scan the sheet and understand status at a glance. Once the tracker is spotless, I need a succinct analysis that surfaces actionable insights. T...

I need a scorecard template for a 10 committee members evaluating 25-30 RFP proposals, formatted as Excel spreadsheets. Additionally, I need an Excel template built to aggregate the scores for the 10 individual scorecards to show who came in 1st, 2nd, 3rd etc Requirements: - Scorecards in Excel - 12 evaluation criteria (to be provided) - Combination of manual entry and automated calculations based on predefined weights Ideal Skills and Experience: - Proficiency in Excel - Experience in creating evaluation scorecards - Attention to detail and organizational skills - Proficiency in building a detailed scorecard AND aggregated template

I release weekly videos around Financial and Economic Concepts to build financial literacy. They are related to money management and investing, and I’m ready to hand off the post-production work to a specialist who understands social-media-first editing. From me you’ll receive 4K talking-head footage, a simple shot, brand assets, and timestamps of the key moments. I need you to turn that material engaging with related data and B-Rolls. You just need to use the data that I speak in the video. I need multiple short, vertical videos for Instagram Reels and a single full video 16:9 version for YouTube. The end result must feel professional and formal—clean jump-cuts, smooth transitions, balanced audio, on-screen titles that echo my brand palette, colour correction. ...

I need an Excel-based Project Cost Tracking Workbook rebuilt from a template so that it functions like a real project controls tool. The current file is based on a personal-budget template, and I need it converted into a proper capital project tracker with AFE logic, PO commitments, actuals, contingency, and monthly performance views. What the final workbook must do: 1. AFE-Based Budgeting Allow me to enter a single AFE (Approved Funding Estimate) for the project. This AFE becomes the master budget and feeds all months. PAFE (pre-approval funding) should be separate and informational only. 2. Categories & Budget Allocation I need to allocate the AFE into cost categories (labor, materials, subcontract, equipment, freight, other, TCDaily, contingency). These budgets must automati...

I need help with organizing a list of event dates in Excel. Requirements: - Use an existing Excel database - Extract dates of events containing the word "Fixed" - Sort these dates in chronological order - Present the sorted dates on a separate sheet - Use standard date format Ideal Skills: - Proficiency in Microsoft Excel - Experience with data sorting and manipulation - Attention to detail

I own a small retail shop and want to record each day’s sales in Excel instead of on paper. The goal is a user-friendly workbook where I simply type the product name and quantity sold and the sheet does the rest—totalling the day and rolling the figures into an ongoing monthly summary I can hand to my accountant. I don’t have any template yet, so you’ll design the structure from scratch. Keep it straightforward: formulas are fine for most calculations, but a light VBA button for “Add New Day” or automatic date stamping is welcome if it makes daily input faster. Deliverables • A clean .xlsx (or macro-enabled) file set up for quick entry of product names and quantities. • Automatic daily subtotals plus a running month-to-date view. • C...

I have an existing workbook that needs to be transformed into a clean, reliable hub for our salary data. All the raw information—employee details, individual salary components, and monthly attendance records—has to be entered accurately, and I want every cell protected by sensible data-validation rules so bad inputs simply can’t slip through. Here’s how I picture the flow. You will take my source files, import or type the data into the appropriate sheets, and build validation drop-downs or rule checks (e.g., text length limits for IDs, date pickers for attendance, numeric boundaries for allowances and deductions). Wherever duplicate records or obvious inconsistencies pop up, flag them so I can confirm the correct values. Deliverables • A polished Excel workbo...

I need a polished Excel dashboard that automatically pulls data from several CSV files and turns it into clear, insightful visuals. The CSVs will be updated regularly, so the workbook must refresh with one click (or on open) without me having to remap the files each time. Here’s what I expect inside the final .xlsx: • Dynamic charts and graphs that highlight key trends. • Clean summary tables for quick reference. • Pivot tables I can filter and slice on the fly. Everything should live on a single-screen dashboard with a professional layout, colour-coded indicators, and slicers or drop-downs where they make sense. Please build it with standard Excel tools—Power Query for the imports, Pivot Charts or standard charts for visuals, and no external add-ins so th...

I want a single, interactive Excel workbook that pulls everything about my vendors into one place. All source data already lives in separate Excel files, so the dashboard simply needs to consolidate those sheets—no databases or APIs involved. The finished model should let me monitor vendor performance scores, on-time delivery rates, and overall spend while also flagging contract compliance issues such as missing supplier registrations or off-contract price changes. I’d like quick comparisons of quoted versus invoiced prices and a calendar view of upcoming delivery dates. Visually, the dashboard must combine: • Dynamic charts and graphs for trends and comparisons • Clean tables or pivot grids for detail drill-downs • KPI indicators (traffic-light icons o...

I already run our home-care clinic with a fairly complex Excel workbook and now need the same functionality, reliability, and ease of use in Google Sheets so the team can collaborate in real time. The current file covers three main areas: patient tracking, financial management, and staff scheduling/maintenance. For every patient we record medical history, appointment schedules, medication details, insurance information, diagnoses, and monthly reminders. On the staff side the workbook logs shift calendars and tracks training completion. The Google Sheets version must: • replicate all formulas, conditional formatting, data-validation rules, and pivot summaries • include simple drop-downs or protected ranges that prevent accidental edits • offer at-a-glance dashboards fo...