Macros Excel Jobs

I need VBA script to execute stored procedure that I have in oracle SQL with some parameter input from excel

I need a professional Excel spreadsheet template designed for my window and door supply business. The spreadsheet will be used to create quotations for builders and clients, so it must automatically calculate areas, prices, and totals. The spreadsheet should be clean, professional, and easy to use. Attached is an example. I will send my company details when chosen

I’m approaching my last assignment, an online exam that will test my overall proficiency in Microsoft Excel, and I want an experienced Excel specialist to guide me through the preparation process. The goal is to make sure I can complete every task confidently during the live assessment, from structuring data correctly to using core features without hesitation. Here’s what I’m looking for: • A short, focused review session to pinpoint any weak spots in my workflow. • Targeted practice questions that mirror the typical exam format. • Clear explanations of why each solution works so I can replicate the steps on my own. • Live walkthroughs—screen-sharing or annotated screenshots—demonstrating the fastest, most reliable methods inside Exc...

I have a clean historical-weather spreadsheet and I want to turn it into a set of engaging dashboards and interactive 3d models. I am trying to prove a thesis that wind direction during winter months contributes to snow blocking a road. The key stories I need to see are: • Predominant wind direction, average wind speed, and peak gusts broken down month-by-month. These should be sliders on a model. • Daily snow-depth trends across the winter, with an overlay or clear link to the prevailing wind direction on each day or month. Focus is on Dec-March Please build whatever pivot tables, Power Query steps, or helper columns you feel are necessary and then surface the insights in a mix of 2D and 3D models—I’d like to be able to switch between the two for presentations. ...

I need an extra set of hands to move a collection of mixed text-and-number records into an Excel workbook and make sure every piece of text ends up neatly grouped by category. Accuracy matters: totals and numerical fields must stay intact, and the category labels should be applied consistently so I can sort, filter, and pivot the sheet without additional clean-up. The source files are ready; you will receive a brief legend explaining each category as well as the column layout I already use for similar jobs. If you have suggestions for small improvements—conditional formatting, simple validation rules, or a more efficient way to separate the categories—feel free to propose them, but my priority is getting a reliable, well-structured file back quickly. Deliverables • Compl...

I need help to make an Excel sheet non-editable. I have already filled in all the details. Requirements: - The main sheet should be view-only, allowing users to view data only. - One specific editable sheet for me or select users. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience with cell locking and permission settings

We are seeking an experienced professional with advanced Excel and Power Query skills to develop a robust production control and traceability system for the swine industry. The goal is to create an organized tool that functions as an efficient database for registering and tracking animal batches from nursery placement to the finishing phase. The system must be able to manage and relate the following production stages: 1. Nursery Placement: * Integrated registration, placement date, number of animals, origin, truck license plate, and farm capacity. * The system must allow multiple placements for the same farm until its capacity is reached. 2. Vaccination Control: * Registration of vaccination date, vaccine name, number of vials used, and number of animals vaccinated. * It must allow m...

I manage a driving school and do weekly payroll calculations for driving instructors. I need a clean, reusable Excel workbook that lets me log regular and overtime hours alongside work-related costs (gas receipts with mileage), and any bonuses earned for each driving instructor (employee). The sheet should automatically roll these daily entries into clear weekly totals, then feed monthly and yearly summaries so I can see trends at a glance without extra work. If you find a simple way to leave space for other cost or earnings categories (bonuses earned) that would be a plus. Core requirements • Input section for each instructor would be Name, Dates of Pay, Regular Hours, Overtime Hours, Regular Pay Rate, OT Pay Rate, Gas Expenses, Mileage, Average MPG, Cost/Mile, Miles Driven...

I have an existing spreadsheet and I need you to build a clean, reusable formula that adds a percentage-based margin across several columns at once. The goal is simple: each product cost already in the sheet should automatically display its selling price after the margin is applied, and any future rows I add must calculate correctly without extra work on my part. You’ll receive the workbook as it is now, along with the exact percentage I use. Please set up the formulas (or structured table columns, if that’s the most robust route) and test them so I can drop in new cost figures and instantly see the margin-adjusted numbers in every specified column. Deliverables: • Updated Excel file with the margin formula in place for all required columns • A brief note or comme...

I’m looking for a clean, well-structured Excel workbook that lets me enter sales figures and all associated costs, then instantly see my profit margins at a glance. Detailed calculations are essential, so every figure—from gross to net margin—should flow automatically from clear, auditable formulas. The file should include: • An input area where I can add or update revenue and expense data without breaking the model. • Formula-driven summaries that display total income, total costs, gross profit, net profit, and margin percentages. • A calculation sheet that performs the heavier analytical work (break-even points, sensitivity toggles, growth comparisons, or any other routine you recommend for deep-dive profitability checks). • A tidy dashboard...

I have a single Excel file holding fewer than 1,000 rows of mixed text and numeric fields. My aim is to identify and flag records that are not exact duplicates but close enough to be considered the same customer, product, or transaction. In other words, I need a reliable fuzzy-matching solution that surfaces these near-matches so I can review and consolidate them. Here is what I need from you: • A working Excel-based approach—formulas, Power Query, VBA, or a combination—that compares the mixed fields and returns a similarity score or direct match flag. • Clear, editable logic so I can tweak thresholds or add new columns later without rewriting the whole thing. • A brief walkthrough (written notes or short screen capture) showing how the matching was set up ...

I have a small Excel sheet that needs precise text-handling formulas. The job is entirely formula-based—no VBA or macros—so I’m after clean functions that split, trim, join, or otherwise reshape text within a handful of columns. Once the formulas are in place and returning the correct results, please return the workbook and a short note that explains what each key formula does so I can tweak it later if needed. This is a quick task for someone who lives in functions like LEFT, MID, FIND, SUBSTITUTE, TEXTJOIN, etc., and I’d like to wrap it up as soon as possible.

I keep all of my renewal data in a single Excel workbook, and every time I need to review information for a specific customer I have to re-apply filters manually. I want that entire routine collapsed into a single click. Here’s what I need: a lightweight automation—VBA, Power Query, or another native Excel approach—that sits inside the file and instantly filters the renewal dataset by customer whenever I press a button or choose a custom ribbon command. The solution must work in standard desktop Excel (Microsoft 365), recognise new rows automatically as the table grows, and preserve any existing formulas and pivot tables. Please deliver a working, macro-enabled version of the workbook (or a clearly commented code module I can import) along with a short set of instructio...

I need an experienced Excel expert to fine-tune my workbook used for data analysis, specifically for generating skill completion reports. The goal is to eliminate any bugs and ensure its long-term reliability. Key Tasks: - Debugging existing formulas and functions - Streamlining report generation processes - Ensuring data integrity and accuracy Ideal Skills and Experience: - Proficiency in Excel, especially in data analysis - Experience with report generation and complex formulas - Attention to detail and problem-solving skills Looking for someone who can deliver a robust and efficient Excel workbook.

I need an Excel expert to help create formulas, specifically for text manipulation. Ideal skills and experience: - Proficiency in Excel, especially in formula creation - Expertise in text manipulation formulas - Ability to work efficiently and accurately Please include examples of past work in your application.

I have a collection of financial figures that needs to be transferred accurately into an Excel workbook. The task is straightforward: type the numbers exactly as provided and apply a consistent currency format so every value displays correctly. Accuracy is critical, as these figures feed into later reporting. I will supply the source material and a blank template; you simply populate the sheet, double-check for entry errors, and ensure the currency formatting is applied throughout. If you are detail-oriented, comfortable working with Excel’s basic formatting tools, and can turn this around quickly, I look forward to collaborating with you.

I’d like a streamlined Excel tool that lets me generate instant cost estimates for flyer jobs in my printing press. The sheet should prompt me for key variables—paper type, quantity, print quality, freight, profit margin, cutting, design, and actual press-run charges—then output a clear per-unit price and grand total that I can copy straight into a client quote. Here’s what I need the workbook to do: • Simple front-end form or clearly labeled input cells for each variable listed above • Behind-the-scenes formulas that add mark-ups, combine fixed and variable costs, and flag any negative margins • An easy-to-read summary section showing subtotal, tax (if I toggle it on), and final figure If you can add optional dropdowns for common paper stoc...

I have an existing workbook that needs a tidy-up from top to bottom. Your first task is to key in a batch of raw data with zero transcription errors, remove any blank or duplicate rows, realign columns where headings or values have drifted, and generally make sure every cell is in the right place. Once the information is clean, I’d like the sheet formatted for quick reading: headings that stand out, columns auto-sized, clear number and date formats, and any simple visual touches (for example basic colour highlights or borders) that make patterns jump out without becoming cluttered. If you spot a chance to add light data validation, a summary formula, or a pivot table that boosts usability, include it and note what you changed. Deliverable: the fully cleaned and reformatted .xlsx ...

I receive fresh sales figures every day in Excel spreadsheets and need each day’s numbers copied accurately into a central Google Sheet that my team uses for live reporting. The job is straightforward but speed and precision are critical—yesterday’s file should already be in the sheet before the next business day starts. You’ll open the provided Excel file, transfer every row and column exactly as-is (no reformatting), double-check totals, and confirm the Google Sheet updates in real time for the rest of the team. A quick note in the comments field once you finish will let me know the upload is complete. I’ll share the template Google Sheet, today’s Excel file, and a brief set of cell-mapping instructions once we get started.

I need help securing an Excel file with a password. Requirements: - Password protection to open the file - Minimum password length of 8 characters Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience with password protection features in Excel - Ability to create secure passwords meeting minimum length requirements

Necesito poner al día todo el catálogo de mi tienda Prestashop utilizando los siete ficheros Excel que me entregan los proveedores (cuatro de 200-400 filas, uno de 7 000 y otro de 5 000). Quiero que cada producto quede correctamente importado o actualizado, respetando las categorías ya existentes y reemplazando la información obsoleta. Lo que espero de tu trabajo: • Mapeo preciso de todas las columnas: nombre, referencia, precio, stock, atributo(s) y cualquier campo adicional necesario. • Carga masiva de imágenes a partir de las rutas o nombres indicados en los Excels, garantizando que cada producto muestre sus fotos en alta calidad. • Sustitución de descripciones y metadatos por los textos que figuran en los archivos. • Conse...

I have an existing Excel-based inventory workbook that has started to behave unpredictably. Data entered in one sheet no longer flows through to the summary pages, several formulas now return #REF! or #VALUE! errors, and the overall stock-on-hand figures are plainly wrong. What I’m looking for is a deep clean of the workbook, with particular attention on the inventory tracking formulas. Please trace the current logic, identify the break points, and rebuild the calculations so that every time new stock is received or sales are logged the counts update instantly and accurately. You will have access to the current .xlsx file plus a short note describing the intended flow. I just need one deliverable: the repaired file, ready for everyday use, with all inventory totals populating c...

I have two practical Excel tasks that I want wrapped up into clean, reusable templates. First, I need a professional-looking invoice sheet. It must automatically pull in client information, list each item or service, calculate totals, display the payment terms with the due date, and show an invoice number and issue date without me having to touch formulas every time. Second, I want a simple stock report that reads my raw inventory data, shows current quantities on hand, and highlights low-stock items so I can reorder on time. A clear summary view and the underlying formulas are both important because I’ll maintain it myself later. You’re free to approach the layout and formulas however you feel is most efficient—as long as everything stays in native Excel with no exter...

I have several Excel spreadsheets filled with raw numbers that now require thorough data entry focused on cleaning and validation. Every figure must be double-checked for accuracy, inconsistent formats need standardising, and any duplicate or obviously erroneous records have to be flagged and fixed. You will be working directly in the existing Excel files, using whatever techniques you find most efficient—formulas, filters, conditional formatting, even light VBA if that speeds things up—as long as the final sheets remain fully functional and easy for me to audit. Deliverables • A clean, validated version of each original spreadsheet, preserving all columns and row order • A brief log (can be a separate tab) noting the corrections made, the rules you applied, a...

I need our customer records transferred and continuously maintained inside a master Excel workbook. The task is straightforward: take raw customer details from various sources, check every field for accuracy, flag any inconsistencies, and then place the clean data into the correct columns of the spreadsheet. Along the way, duplicate contacts must be merged, outdated entries archived, and sensitive information handled with complete confidentiality. You will work only in Excel, so fast navigation, solid formula knowledge, and an eye for data integrity are essential. A typical batch will include names, addresses, phone numbers, emails, and a few custom notes; speed is important, but precision matters more. I review every submission against our validation rules, so please be ready for the occ...

I have a raw Excel workbook that needs to be transformed into a clear, reliable reporting file. The core of the job is to build well-structured pivot tables that let me 1) summarise the data quickly, 2) apply flexible filters, and 3) compare key figures side by side. Once the pivots are in place I also want a tidy report sheet—pivot charts or formatted tables are fine—as long as the numbers update automatically when new data is dropped in. You will work directly in Excel (desktop version, not Google Sheets) and keep the solution formula-driven—no macros required. Final deliverables: • The updated workbook with all pivot tables, slicers (if helpful), and a finished report tab • A short set of notes or screen-recording showing how to refresh the data and modif...

I need an Excel-based dashboard, driven by VBA, that runs entirely offline and guides pharmacists and clinicians through chronic kidney disease and cardiovascular risk screening. The workbook must accept three kinds of patient inputs: demographics with medical history, current lab tests and vital signs, plus any active medications or treatment plans. As soon as the user enters or pastes that information, the tool should automatically calculate evidence-based risk scores, assign the correct CKD stage, and display clear on-screen prompts for next clinical steps—no internet look-ups, external add-ins, or cloud calls allowed. Fast, intuitive navigation is essential because the primary users will be frontline pharmacists and clinicians working in low-resource settings. I’m envision...

Quiero un dashboard dinámico en Excel que me permita seguir el rendimiento diario de mis ventas. Proporcionaré la base de datos cruda y necesito que la transformes en un panel claro y visual que incluya las siguientes métricas: • Cantidad de ventas • Ingresos generados • Número de clientes . Otros dato relevante para la base de datos que aportan valor. Tengo prioridad en el análisis de las ventas diarias, así que la estructura debe destacar ese horizonte temporal y permitir filtrados rápidos por fecha. No indiqué un tipo de gráfico concreto porque estoy abierto a sugerencias: barras, líneas o la combinación que consideres más intuitiva para comparar tendencias. Entrego el archivo de ...

I need our customer records transferred and continuously maintained inside a master Excel workbook. The task is straightforward: take raw customer details from various sources, check every field for accuracy, flag any inconsistencies, and then place the clean data into the correct columns of the spreadsheet. Along the way, duplicate contacts must be merged, outdated entries archived, and sensitive information handled with complete confidentiality. You will work only in Excel, so fast navigation, solid formula knowledge, and an eye for data integrity are essential. A typical batch will include names, addresses, phone numbers, emails, and a few custom notes; speed is important, but precision matters more. I review every submission against our validation rules, so please be ready for the occ...

I need a single Excel-based application that lets me run a small motorcycle fleet as smoothly as possible. The workbook should allow me to: • Enter a reservation once and have the sheet immediately flag that motorcycle as unavailable for overlapping dates. • Store every reservation in a permanent log that I can filter by bike, customer name, or date range, so I can review usage patterns or settle disputes later. A clean front end (forms, drop-downs, or slicers) is important because different staff members will be using it each day. Behind the scenes you’re free to rely on formulas, tables, Power Query, or VBA—whatever delivers quick automatic availability updates and a reliable, searchable booking history without corrupting the data. Acceptance criteria –...

I need a single-file Excel dashboard that shows, at a glance, how I am performing against the daily, weekly, and monthly targets below. Each morning I will paste or type the previous day’s raw numbers into a data sheet; the dashboard sheet must then refresh automatically and display progress with a bright, vibrant look. Targets to track • DTC – Outbound calls: 20/day, 100/week, 430/month • DTC – Bundles sold: 75 % of total sales • B2B – Prospective emails: 13/day, 65/week, 280/month • B2B – Call rate: 13/day, 65/week, 280/month • B2B – Follow-up emails: 13/day, 65/week, 280/month • B2B – Sales call with decision maker: 3/day, 15/week, 65/month • B2B – Practices sent samples: 20/month • ...

I’d like an Excel-based workbook that lets me log sales and expenses for my retail operation and instantly see my profit or loss. The file should do more than just total columns—I need meaningful sales analytics and clear expense categorization so I can spot trends without manual number-crunching. Core requirements • Simple data-entry sheets for daily sales and for each expense type, with drop-down categories I can edit later. • Automated calculations that roll into a clean Profit & Loss summary. • Interactive sales analytics: charts, pivot tables or a small dashboard that highlights best-selling items, daily/weekly revenue, and margins. • Built-in expense categorization so I can filter or pivot by cost type. • All formulas locked from ac...

Potrzebuję czytelnego grafiku pracy w Excelu dla mojego zespołu. Harmonogram ma zawierać godziny pracy każdego pracownika oraz odnotowane dni wolne i urlopy. Nie planujemy zmian nocnych, dlatego arkusz powinien przewidywać wyłącznie zmiany dzienne. Chciałbym, aby plik wykorzystywał: • kolorowanie komórek – różne barwy dla standardowych godzin, nadgodzin i urlopów; • tabele przestawne – żebym mógł szybko podsumować liczbę przepracowanych godzin według osoby i tygodnia; • przejrzyste formuły, które automatycznie sumują godziny i kontrolują, czy pracownik nie przekracza dziennych ani tygodniowych limitów. 5 pracowników 2 na pełen etat 3 na 1/2 etatu Zrobić grafik na marzec Jest to grafik do sklepu w galerii ...

My current spreadsheet records each paper-reel size, BF and GSM, yet every week I still find myself scrolling through rows to know what to order. I now want a single Excel workbook that handles the whole flow for me: I type in a new delivery, the file increases stock; I enter a production run, stock comes down automatically; and, at a glance, a dashboard highlights reels that have hit their reorder point. Key features I need built into Excel: • Automated stock reduction driven by my consumption entries • Clear reorder alerts—colour-coded and, ideally, a pop-up or email trigger when a threshold is crossed • Detailed summaries: current balance by size/BF/GSM, monthly usage, ageing stock, and a concise “Order Now” list I will be entering data manually...

I need assistance with coding a spreadsheet, specifically with formulas and calculations. Description: Okay so this is the brief of what I want to do and I dont know what is exactly possible but thought one of your excel gurus would probably figure it out in like 5 mins and could maybe give me some direction: Attached is the spreadsheet which we want to keep all of our jobs that we do in one place so we have the job cards auto populating form the main table and will give us data on the work we have done. I have created the main sheet so as you populate each cell (some are data validation drop downs and some are manual inputs) it pulls through to the job card sheet. How do I make it so each line creates its own job card? I have just done a simple formula for Line 1 but need it that a ...

I need a dynamic Excel sheet to manage furniture SKUs. The sheet should allow me to: - Input images of SKUs - Update stock levels daily - Filter and display only in-stock SKUs with corresponding images and quantities - Export the sheet to PDF format - Use a grid view layout Ideal skills and experience: - Advanced Excel proficiency - Experience with dynamic data and image handling - Ability to create user-friendly, automated filters