Visual Basic Jobs

I need help with 10 intermediate-level Excel assignments for school. Tasks include: - Data entry and organization - Creating charts and graphs - Performing calculations and functions Ideal skills and experience: - Proficiency in Excel - Strong attention to detail - Ability to meet deadlines

I have a steady stream of records that need to be keyed in every day for the next four weeks. The workload is consistent rather than overwhelming, so what matters most is accuracy, reliability, and the ability to keep to a simple daily schedule. You will receive the source files each morning, and I’ll expect the completed spreadsheet back by the end of the same day so I can run my checks overnight. For quality control I’ll be spot-checking at least 5 % of the rows; anything above a 1 % error rate will have to be corrected before the next batch goes out, so solid attention to detail is essential. I’m flexible on the platform—Excel, Google Sheets, or another tool you prefer—as long as the final file is compatible with standard .xlsx or .csv formats. Please...

I’m gathering quotations from roughly a dozen food-service suppliers and need a clean, reliable Excel file that lets me and you plug each quote in and instantly see where we can save money. Structure I have in mind • One master workbook with a dedicated tab for every supplier (expect 10–12). • A dynamic summary tab that automatically identifies the best supplier overall for every line item, taking into account weight and pack-size differences. possible colour coded • Built-in calculations for total costs per supplier, potential savings against a current baseline, and any weight/pack-size conversions so we’re always comparing like with like. Presentation requirements • On the final tab I want a clear “best supplier overall” view, p...

I have a stack of printed forms that now need to live in a clean, well-structured Excel spreadsheet. Every field on each form must be keyed in manually—no OCR or automated scraping—so close attention to spelling, numbers, and formatting is critical. The sheet you return should mirror the form layout: each column clearly labeled, each row representing a single form, with no merged cells or hidden formulas. I’ll review the file against the originals, so accuracy must be spot-on and any illegible items flagged for clarification rather than guessed. If you’re comfortable working quietly and methodically with Microsoft Excel and can keep the source paperwork confidential, this will be a straightforward job. Let me know your expected turnaround time and how you ensure...

I have several Excel spreadsheets that contain a mix of text and numerical fields. They need a thorough pass of data cleaning and validation so the information is consistent, accurate, and ready for downstream analysis. The job centres on: • Removing duplicate or irrelevant rows • Correcting formatting issues (dates, decimals, text case) • Flagging and resolving inconsistent or out-of-range values • Verifying that key fields match predefined validation rules Please return a fully cleaned workbook along with a brief summary of the issues you found and the actions you took. Consistent use of Excel’s built-in tools, formulas, or Power Query is fine—whatever you normally deploy for reliable results—as long as the final file is error-free and easy...

I need my existing workbook to do more of the thinking for me. Right now each process is logged manually, but the column that should show who is responsible is blank. Your task is to insert the right data-analysis formulas so that, as soon as a process code or other key detail is entered, Excel automatically returns the correct “responsible” name. You may lean on lookup combinations, conditional logic, or any other native functions that keep the file fast and easy to edit; lightweight VBA is acceptable only if a purely formula-based route proves impossible. The sheet layout should remain intact—no moving columns or renaming headers. Deliverables • Working formulas (or compact VBA) that populate the “Responsibility” field for every current and future r...

I have a set of existing spreadsheets filled with plain text records that now need to live in clean, well-structured CSV files. Your task is to pull every row from those sheets, check that the headings stay consistent, and export the results as UTF-8 CSV without introducing any hidden characters or broken line breaks. The spreadsheets are already organised, so no deep data cleansing is required—just tidy up obvious spacing issues, preserve punctuation, and make sure every cell ends up in the correct column position in the final CSV. I will share the sheets in either Google Sheets or Excel; work in whichever environment you prefer as long as the finished deliverable is a set of ready-to-import CSV files. Deliverables • One CSV per source sheet, correctly named and enc...

I need a clean, reusable Excel workbook that lets me do two things from the same file. First, track daily attendance in a simple table that shows each employee’s name, check-in time, check-out time, and total hours worked. Second, have those attendance figures feed seamlessly into a salary-slip sheet so I can generate individual payslips at month-end without re-entering data. A formula-driven solution is my priority, but I’m open to lightweight VBA if it keeps everything one-click simple. The layout must stay fully editable, as different teams may add or hide columns later. Please deliver: • A master attendance sheet with automatic date handling and clear data-validation for time entry • Dynamic formulas (or macro) that calculate total hours per person per day and...

I have a stack of Excel homework that is almost entirely data-entry focused and spans well over ten individual worksheets. Every sheet is already formatted; I simply need the correct figures transferred from source PDFs into the proper cells without breaking any of the existing formulas. Accuracy comes first. I will spot-check random rows, so typos or mis-aligned entries will be sent back for revision. Because there are more than ten sheets, I’d like someone who has proven experience handling large, repetitive data loads while maintaining consistency. Deliverables • All homework sheets returned in the original workbook structure, fully populated and saved in .xlsx format • A quick message summarising any anomalies you noticed (e.g., missing source values) If you have...

I need a fully automated Excel bill for my trading business. The Excel sheet should be capable of generating invoices automatically. The invoices need to include: - Customer information - Product details - Payment terms Ideal skills and experience: - Advanced Excel skills - Experience in creating automated Excel templates - Attention to detail - Prior experience in invoicing for retail or trading businesses Please provide samples of similar work done.

I need a seamless link between Xero’s API and an Excel workbook that automatically pulls the standard financial reports—Profit & Loss, Balance Sheet, Cash Flow and any other off-the-shelf statements—directly into Excel every day. No custom fields are required; the default columns Xero provides are perfect. The workflow should: • Authenticate securely with Xero’s API. • Drop each report into its own tab in a refreshable .xlsx file. • Allow a quick manual refresh in Excel (Power Query, VBA, Office Scripts, Python, or comparable approach is fine) in case I want an on-demand update. • Be simple to maintain if Xero tokens expire or if I need to adjust the date range. Deliverables: 1. Fully working connection script or add-in. 2. An E...

I have a set of existing spreadsheets filled with plain text records that now need to live in clean, well-structured CSV files. Your task is to pull every row from those sheets, check that the headings stay consistent, and export the results as UTF-8 CSV without introducing any hidden characters or broken line breaks. The spreadsheets are already organised, so no deep data cleansing is required—just tidy up obvious spacing issues, preserve punctuation, and make sure every cell ends up in the correct column position in the final CSV. I will share the sheets in either Google Sheets or Excel; work in whichever environment you prefer as long as the finished deliverable is a set of ready-to-import CSV files. Deliverables • One CSV per source sheet, correctly named and enc...

I’m looking for an experienced Power BI developer to build a financial dashboard that provides clear visibility into performance, with a strong focus on budget vs actual analysis and KPI tracking. All underlying data will be provided in Excel format. The goal is to transform this data into a clean, interactive, and management-ready dashboard that supports decision-making. Scope of Work • Review and structure the provided Excel data • Build a robust data model within Power BI • Create DAX measures for key financial metrics • Develop an interactive dashboard with filters and drill-down capability Key Metrics to Include • Revenue, Costs, and Net Profit • Budget vs Actual (with variance analysis) • Monthly and Year-to-Date (MTD/YTD) performa...

We need an Excel VBA quotation system (offline) for a windows & doors company. The system must include: A protected Admin Pricing Sheet where only admin can control all prices (designs, materials, colors, glass, screens, key lock, installation rates, delivery rate). A Customer Database where users can add customers, but cannot edit or delete them without admin approval. Customers must be searchable and auto-filled into quotations. A Quotation system where: - Quotation number is automatic - Date is automatic - Expiry date is +15 days - User selects customer, adds salesperson name and remarks Each quotation must support multiple line items. Each line includes: Design, Material, Color, Glass, optional Screen, optional Key Lock, Width, Height, Quantity. The system must automatically...

I have a set of raw transactional records sitting in several CSV files. I need them imported into Power BI, cleaned, and reshaped into a star-style model. The core relationships I must see are Customer → Orders and Region → Revenue; anything else you add for best practice is welcome provided it remains documented. Once the model is in place, create DAX measures for: • Total revenue • Number of orders • Distinct customers • Return rate With those measures, build visuals that show: • Revenue distribution by region • Seasonal revenue patterns (month and quarter) • Any revenue-concentration risk—e.g., regions or customers that contribute a disproportionate share • Key performance trends over time I will consider the job c...

I keep a master list of text in Excel and need the same strings to appear in set bookmarks inside a lengthy Word document. Manually updating each spot is getting out of hand, so I want to automate the round-trip. The core job is to write reliable VBA/macros that will: • Pull text data from specific Excel cells. • Match each cell to its corresponding Word bookmark. • Push the new text into Word at the click of a button (or Workbook_Open/Document_Open event). • Offer a simple “refresh” command so I can rerun the sync whenever the spreadsheet changes. • Handle errors gracefully (missing bookmark, blank cell, Word not open, etc.). Nice-to-have: If a bookmark’s text is edited directly in Word, a reverse sync back to Excel would be a bonus. ...

I need a freelancer who can convert 144 DTA files into Excel files, with each DTA file being converted into a single sheet in an Excel file. Key Project Details: - Each DTA file should be converted into a single sheet in an Excel file. - There is no need for any data cleaning or processing during the conversion. The task is strictly to convert the files. - The converted Excel files should use the original file names. Ideal Skills: - Proficiency in data conversion and Excel. - Familiarity with DTA file format is a plus. - Attention to detail to ensure accurate file naming and conversion.

I have a collection of Word documents that hold nothing but numbers—mostly tables of sales figures, inventory counts, and a few one-column lists. I need every single value lifted out of those digital files and placed accurately into a clean, well-structured Excel workbook. The job is straightforward but detail-sensitive: • Open each Word document and extract the numbers exactly as they appear. • Paste or type them into the matching rows and columns of the Excel template I will provide. • Keep original number formatting (decimals, commas, negatives) intact. • Double-check totals with simple SUM formulas so we can spot any discrepancies instantly. When you are done, I expect one Excel file that mirrors the order of the source documents, plus a brief note of any ir...

Project Title: Firebase Web App Foundation + Dashboard Shell (Google Ecosystem, Modular and Scalable) Project Description: I am building a web-based trucking operations platform. This contract is ONLY for the first foundation section of the project, not the full system. The goal of this first job is to create a clean, professional, modular foundation that can support future modules later. I want the project to start in the Google ecosystem for speed, low cost, and ease of launch. However, the code must be structured cleanly enough to support future scaling, refactoring, or migration into a larger architecture if needed. This is a small foundation contract only. I am NOT hiring yet for the full platform. Preferred Stack: - Firebase Authentication - Firestore - Firebase Storage - Fireb...

My Excel workbook already contains a VBA macro that opens a PDF, extracts targetted numeric value from certain columns, aggregates them, and drops the results straight into specific cells. Functionally it works, yet it generates errors when it comes accross different number formats. I need a fast, tidy rewrite (or smart port) that does the same three core steps—read, parse & aggregate, write—within roughly three hours of coding time. You can choose the approach that lets you move fastest: streamline the existing VBA, replace it entirely with a Python routine built around pdfplumber, or create a hybrid where Python performs the heavy lifting and VBA simply updates the sheet. I’m comfortable with any of those paths as long as the final workbook remains a one-click solu...

I have a single Excel spreadsheet that I need turned into a PDF. Basic visual structure—column widths, row breaks, and simple font sizing—should look the same, but I’m not worried about exact color matching or advanced styling. Please send back a clean, ready-to-share PDF file that opens without warnings on standard viewers (Adobe Acrobat, browser preview, etc.). One quick pass is all that’s required; as soon as the page layout matches the worksheet and everything is legible, we’re done.

I need an end-to-end n8n workflow that pulls data from two main sources—uploaded CSV/Excel files and live Google Spreadsheet tabs—then lets me ask for a custom report, have AI compose the narrative, export the result to a fresh .xlsx file, and add whatever chart the request calls for (bar, line, pie, or any other common type). Here is how I picture it working: • Data intake: watcher or manual trigger accepts a spreadsheet or points to a specific Google Sheet range, cleans and validates the dataset. • AI step: a prompt-driven node (OpenAI, GPT-4, or similar) summarises insights and structures the text for the report according to the question I write in plain English. • Report assembly: tables, headings, and the chosen chart are combined, then saved as a mult...

I’m looking for a clean, reusable sales-invoice template built entirely in Microsoft Excel. The finished workbook must let me enter customer details, list product descriptions, and spell out payment terms without breaking the layout. For the product section I’d like full flexibility—sometimes a single line per item is enough, other times I need multiple descriptive lines or even a category breakdown. Please structure the sheet so any of those views can be shown or hidden easily. Automatic line totals, subtotal, tax, and grand-total formulas should already be in place, and all cells where I’ll type data clearly marked. A spot for my company logo and address would be helpful too. Deliverable: • One unlocked .xlsx file ready to use and modify later. If you&rsq...

PROJECT: Excel-Based Quotation System with Admin Control (MODA Windows & Doors) We need to develop a quotation system using Microsoft Excel (offline), with structured pricing logic, admin-controlled pricing tables, and manual PDF export. The system must be easy for sales users to operate while maintaining full control of pricing by the admin. 1. USER ROLES & ACCESS CONTROL There are two types of users: Admin Has full access to all sheets, including Pricing List and Customer Database. Can edit all pricing, unlock protected areas, and manage the system. User (Sales) Has access only to: - Customer List (restricted editing) - Quotation Sheet (data entry only) User cannot: - Access or modify Pricing List - Change formulas or pricing logic - Delete or edit customers without admin...

I'm looking for an Excel spreadsheet that will help me manage customer data effectively. The spreadsheet should include features for timeliness tracking and to-do lists. Key Requirements: - Establish timeliness needs for various tasks - To-do lists generated from a fixed data set of customer information - Organized layout for easy data entry and analysis Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in creating customized spreadsheets for data management - Strong organizational skills

When I export my .xlsx workbook to PDF, what should be a single-page printout gets split across two pages. In Excel’s print preview everything fits neatly on one sheet, so I know the layout is correct inside the file; the problem appears only at the PDF stage. The sheet contains a mix of text labels and numerical data, no external links or macros. I need someone who can dive into the page-setup settings, scaling, margins, printer drivers or any other culprit and deliver a PDF that mirrors the one-page view I already see inside Excel. Ideally you’ll explain the tweak so I can apply it to future sheets too. Deliverable: • Updated workbook (or documented steps) that consistently exports to a single-page PDF matching Excel’s print preview.

I have a set of raw financial figures that still need a bit of tidying before they can reveal their story. Once the data is properly formatted in Excel, I need clear, well-labeled outputs for these descriptive measures: mean, median, plus the full spread of quartiles and percentiles. Please structure the workbook so that the cleaning steps (date or currency standardisation, removal of blanks, etc.) are transparent, then create the calculation area—whether that is with built-in functions, dynamic arrays or PivotTables is up to you, as long as the results update automatically when new records are dropped in. Deliverables: • A single Excel file containing: – A “Raw_Data_Clean” sheet with all prep formulas in place – A “Stats_Summary&rdquo...

I have a batch of files containing both text and numerical values that need to be transferred into a clean, well-organized Excel worksheet. There are no special templates, validation rules, or conditional formats to worry about—just straightforward, high-accuracy entry into the default spreadsheet layout. You’ll receive the raw data in the format that is easiest for you to process (PDF, Word, or scanned images if preferred), and I’d like the finished work returned as an .xlsx file. My priority is absolute accuracy and a quick turnaround, so please work carefully, double-check for typos or transposed numbers, and keep the sheet tidy. If questions arise while you’re keying in the information, let me know right away so we can keep the workflow smooth. Looking forward...

I have several Excel spreadsheets filled with statistical entries recorded on different dates. I need the date columns repaired and standardised first, then a reliable way to compare each entry across the sheets so perfect matches surface immediately. Once the data is aligned, A small dashboard or set of charts inside the workbook is perfect; I want to see the movement at a glance. Everything must stay in .xlsx format. Use familiar Excel tools—formulas, conditional formatting, PivotTables, maybe Power Query if it speeds up the cleaning—so I can inspect or tweak them later. Deliverables: • Cleaned and consistently formatted spreadsheets • Automated comparison logic for the date-based entries • Standard deviation results for each metric • Tren...

I need a skilled developer to extract data from our field service software, Eworks, using their API. The extracted data will be used in Excel. Requirements: - Data Types: Service reports, customer information, and fieldworker schedules. - Structure: Data should be organized in Excel using pivot tables for aggregated views. - Update Frequency: Data needs to be refreshed and updated daily. Ideal Skills and Experience: - Experience working with APIs, particularly Eworks. - Proficiency in Excel, especially in creating and managing pivot tables. - Ability to set up automated data extraction and updates on a daily basis.

I need an Excel solution to automatically fill profit and loss and balance sheets for different subsidiaries through a consolidated sheet. The consolidated sheet must update in real-time. Requirements: - Use Excel for automation - Real-time updates on financial data - Initially set up to allow for manual data input Ideal Skills and Experience: - Proficiency in Excel, especially in data automation and real-time updates - Experience with financial statements and consolidation - Strong problem-solving skills to create a seamless integration for manual data input

I have several spreadsheets that need accurate, timely data entry directly in Microsoft Excel. Your task is to take the raw information I provide—names, numbers, text notes—and record it in the correct columns and rows so everything is clean, consistent, and ready for reporting. The work is strictly data entry rather than analysis, but attention to detail is crucial because these sheets feed into other parts of my workflow. If you are comfortable with standard Excel functions like quick sorting, simple validations, or setting up drop-down lists, that will help keep the files error-free, though no complex formulas are required. I will supply clear instructions, the source files, and a small sample so we can confirm format before you begin the bulk of the job. Accuracy, confide...

I need a single, central Google Sheets workbook that keeps every maintenance detail for 14 identical machines: the fault reported, the date it was fixed, the part involved, and the next scheduled replacement. Each machine will have a unique QR code mounted inside its housing; when a tech scans it, a short, machine-specific form should open, capture the data, and feed it straight back into the master sheet with a time-stamp and the machine ID already filled in. Because the QR codes are part of the workflow, I’d like the solution to generate them automatically—no external websites or manual downloads—so everything remains self-contained. Once the data lands in Google Sheets, the system must watch the “next replacement” column and fire off an email whenever a ...

I want every click, scroll and bounce on my store translated into a clear, Excel-based story I can act on. You’ll pull fresh data from GA4, structure it into well-designed spreadsheets, and highlight the website traffic patterns that matter most. While traffic is our headline focus, I also need revenue growth tracked side-by-side so I can see how new customers are contributing to the bottom line in real time. Here’s how I picture the collaboration: • Build dynamic Excel dashboards fed directly by GA4 exports or the API. • Surface actionable insights on traffic sources, on-page behaviour and funnel drop-offs. • Tie those insights back to revenue growth, isolating performance for new customers versus everyone else. • Meet with me regularly to walk thro...

I have been running my numbers in spreadsheets for far too long and now need a properly structured Microsoft Access solution. The goal is to design and optimise a database whose sole focus is managing financial data—specifically our invoices and billing records. Here is what I need from you: • A relational schema that keeps the tables normalised, eliminates duplicate data, and supports growth. • Intuitive forms for entering new invoices, applying payments, and updating client details without exposing raw tables. • Parameter-driven queries and summary reports that let me filter by client, date range, paid / outstanding status, and export cleanly to Excel or PDF. • Thoughtful use of indexes, validation rules, and VBA where necessary so the system stays fast ...

I need a clean, well-structured financial statement built directly inside Microsoft Visualizer. The finished file has to present two core sections: • Client Statement – a clear snapshot of the account that shows current positions, cash balance, deposits, withdrawals, fees and any other relevant adjustments. • Trade Confirmation – a line-by-line record of every executed trade with date, symbol, side, quantity, price and total value. A single Visualizer file that I can open, edit and export to PDF is the primary deliverable. Please lay it out so figures update automatically if I change the underlying data and make sure fonts, colours and tables stay consistent with typical financial-report styling. If you have previous statements, please share a screenshot when y...

I have a short Excel VBA procedure called Sub AboutMe( ) that pops up a message box introducing me. I now need a clean, well-commented revision of that macro so the entire prompt appears in Hindi and also shows my contact information directly in the same MsgBox. Key points you must cover while editing the code: • Replace the existing mixed-language text with full Hindi phrasing. • Append a concise contact line (phone / email placeholder is fine; I will fill real data later). • Keep the procedure lightweight so it runs in any standard Excel workbook without additional references. Please return: 1. A .bas or .xlsm file containing the updated macro. 2. Brief instructions (one or two lines) on how I can change the contact string myself whenever needed. If you ca...

I have an existing monthly-budget workbook that already tracks income and savings, but the expense side is lagging behind. I need you to dive into the Expenses section, review the current cells and ranges, then build or correct the formulas so every expense line rolls up cleanly into a monthly total and feeds the year-to-date view. The sheet is laid out clearly, so this is mostly a formula and cell-reference task: SUMIF/SUMIFS, structured references, and a few conditional calculations for overspend alerts. No macros are required; pure Excel functions are fine. Once finished, I should be able to drop new numbers into each daily or weekly expense row and see the monthly forecast adjust automatically. Deliverable: the updated workbook with transparent, commented formulas in the Expenses are...

I'm looking for someone to help streamline my quoting process using Excel, Word, and OneDrive. Requirements: - Template unification across Excel and Word - Modify existing templates as needed - Improve overall document organization Ideal Skills: - Proficiency in Excel, Word, and OneDrive - Experience in template creation and modification - Strong organizational skills - Ability to automate calculations and enhance workflow efficiency Please provide examples of similar work done.

Project Overview I have an existing Excel workbook used for job costing in a construction/striping business. The workbook is already functional and calculates costs based on quantities entered across multiple sheets (organized by item types such as striping widths, colors, markers, removals, etc.). Each sheet calculates unit pricing based on quantity tiers and produces totals. However, my current summary sheet only shows category totals (e.g., total striping, total removals) and does not provide a detailed, itemized breakdown. What I Want to Achieve I need to create a final summary sheet that dynamically pulls and displays ONLY the items used in a job, including: Item description (ex: 4” White Stripe, RPM Marker, etc.) Quantity entered Unit cost (based on the pricing logic alrea...

Each month I have a small, repeatable task that takes about half an hour: entering and checking mixed text-and-numeric data that arrives in a spreadsheet. The flow is always the same, so once you understand the routine it should feel quick and predictable. Accuracy matters more than speed, and I need the file returned on the agreed date every month without exception. Because the dataset is drawn directly from spreadsheets, you’ll simply open the source sheet, copy or key the mixed fields into the target file, make sure everything lines up exactly, then save and send it back. That’s it—no complex formulas, no macros, just careful data handling. I’m only able to work with U.S.-based freelancers for this role. If you have reliable month-to-month availability and a ...

I need our simple logistics data-entry workbook turned into a smarter, mostly hands-off tool. Right now staff key information into a single base sheet, then we spend extra time copying, filtering and re-formatting that same data before it can be e-mailed to clients. I want to keep the base sheet as the only place anyone touches the raw figures, but have the rest happen automatically: • Guided data input – drop-downs, look-ups or forms that prevent typos and ensure each required field is filled. • One-click data output – macros or Power Query that transform the base data into clean, customer-ready sheets (PDF or XLSX) and save them to a specified folder, ready to attach to an e-mail. Because all finished files go out as e-mail attachments, the generated sheets mu...

I need a single Excel workbook that can serve as an issue register for roughly twenty ongoing projects. Each project will sit on its own sheet, and every sheet must let me log: • the date an issue is booked • its target closure date and actual closure date • a status field with the options Open, In Progress, or Resolved • the name of the resource responsible for that issue Across the whole file I want a compact dashboard, shown as summary tables, that rolls everything up in real time. At a glance I should see: • total issues booked • total issues still open • total issues closed / resolved A simple date-range filter is essential so I can instantly list all deliverables that remain open (or moved to Resolved) between any two dates I choos...

I have several up-to-date Excel workbooks that hold our raw sales data, and I want them transformed into an interactive Power BI dashboard focused squarely on sales performance. The core metrics to surface are: • Total revenue • Sales growth over time • Top-selling products, with the ability to drill down by category or period Everything sits in Excel today, so the first step will be organising clean data connections and refresh schedules from those files into a single Power BI model. Once that model is solid, I need clear, visually engaging reports—think KPI cards, trend lines, and ranked product visuals—that make it easy for the team to spot patterns and act quickly. Deliverables • A fully functional .pbix file connected to my Excel sources &bul...

I need a quantity surveyor - engineer who lives and breathes construction to build a suite of Excel workbooks completely from scratch. These files must let me: • Prepare detailed estimating sheets that roll into a clean, client-ready quote. • Track project progress, variations and key dates as a live project-management dashboard. • Generate daily site reports, monthly summaries and forward-looking cash-flow reports at the click of a button. • Monitor incoming and outgoing payments so I can see our real-time financial position. The final spreadsheets have to be intuitive for site staff yet robust enough for head-office reporting. Smart use of formulas, named ranges, drop-downs and conditional formatting is expected; VBA or Power Query is welcome if it keeps routi...

I need a single Excel workbook that lets my office staff, most of whom have only basic spreadsheet skills, run every day-to-day aspect of our small manufacturing unit. We make roughly 15–20 different products and I want each batch, sale, return, purchase, expense and salary entry captured in one place, then automatically summarised for quick decision-making alongside a convert to json (for single entry or the entries that we select or per day so that we can have a file that is ready to be uploaded on tally as well) and all the sheets of the work book should be interconnected so that we dont have to enter a single entry multiple times Core flow • A simple “daily entry” interface where staff can pick the date, choose the item, state quantities produced, sold or retu...

I need a single Excel workbook that lets me monitor four different products from the moment they come into stock until they reach my customers each week. The file must show, at a glance, how many units I still have on hand, how many went out this week, and the exact date each order was placed. The only way I want to add customer orders is through a clean, user-friendly form—no typing directly into tables. When I open the form, I should be able to pick the product, enter the quantity requested, choose or type the customer name, and hit submit. As soon as I do that, the workbook should automatically: • deduct the quantity from the correct product’s stock balance • stamp today’s date (or the date I select) as the order date • log the transaction so w...

I need a clean, branded Excel file that lets me build product-only quotations quickly while still looking fully professional to my clients. The sheet has to show, at minimum, columns for Product Name, Product Description, Quantity and Unit Price, with automatic line totals, subtotal, tax and grand total calculations. I sometimes attach images to help the client visualise an item, so please leave space or an optional column that can accept embedded pictures without breaking the layout. A few other things will make the file truly useful to me: my company header and contact block locked into place, space for the client’s details, auto-generated quotation number and date, clearly formatted terms & conditions at the bottom, and colour-coded cells so it’s obvious which fields I ...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.