Excel VBA Jobs

Necesito que diseñes en Excel un informe de flujo de caja mensual, claro y profesional, que pueda actualizarse fácilmente cada periodo. Qué busco: • Un archivo maestro en Excel con hojas bien estructuradas para ingresos, egresos y consolidado. • Fórmulas y vínculos automáticos que calculen saldos iniciales, finales y variaciones mensuales. • Gráficos o tablas dinámicas opcionales que resuman las principales métricas de liquidez. • Celdas protegidas y formato limpio para evitar errores de edición. Entregarás: 1. El libro de Excel completamente funcional. 2. Breves instrucciones dentro del mismo archivo (o en un PDF) sobre cómo alimentar los datos mes a mes. 3. Comentarios en l...

I have a collection of customer details that need to be transferred into a single, well-structured Excel workbook. The task is straightforward: capture each person’s name, phone number, and email address exactly as provided, place them in clearly labeled columns, and make sure formatting is consistent throughout. Accuracy is everything—no duplicates, no misplaced numbers, and no partial emails. When you finish, I should be able to sort, filter, and search the sheet without worrying about hidden errors. Deliverable: • A clean .xlsx file containing every customer’s full contact details, ready for immediate use.

I’m looking for reliable support with the full run of our daily HR administration. The bulk of the work centres on two areas that urgently need tightening up: attendance and leave. Right now everything is logged manually in paper sheets or basic Excel tabs, so I need you to rebuild this into a smarter workbook that: • calculates working hours automatically from in-out times, • refreshes attendance data in real time (as soon as new rows are entered), and • produces clear monthly summaries I can forward straight to management. Alongside that core file, you’ll handle routine HR tasks—entering new-hire data, maintaining personnel records, tracking leave balances, and preparing official letters or notices. Accurate payroll data will flow from the cleaned...

I’m looking for a detail-minded Excel expert who can turn my day-to-day accounting spreadsheets into a largely self-running system. What I already have • Well-maintained bookkeeping, A/P, A/R, payroll, and financial-reporting data, all in separate Excel files. • A clear understanding of the results I need—but the calculations still involve too much manual effort. What I need from you 1. Review my current workbooks for consistency and accuracy. 2. Build (or refine) formula-driven automation that performs recurring calculations for bank reconciliation, aging schedules, payroll totals, and financial statements. 3. Configure dynamic tools—named ranges, pivot tables, lookup formulas, and dashboards—so reports update automatically when I paste in f...

I need a comprehensive Excel template for financial tracking, specifically for budgets and invoices/billing. The template should also include auto-calculation of totals and taxes for invoices. Key Requirements: - Budget tracking - Invoices and billing management - Auto-calculation of totals and taxes on invoices Ideal skills and experience: - Proficiency in Excel - Experience in creating financial tracking templates - Attention to detail and accuracy

I need a reliable pair of hands to move alphabetic text from my source files into a clean, well-structured Excel sheet. The material is letters only—no numerics—so accuracy in spelling and case is critical. I will supply the layout I want for each column; your job is simply to copy the text over, double-checking that nothing is added, dropped, or rearranged. If you have a solid track record handling similar Excel data-entry jobs, let me know how many projects you have completed and the typical turnaround time you achieve. A short note on the tools or methods you use to keep your error rate low would also be helpful. Deliverable: • One Excel workbook populated exactly as specified, ready for immediate use. I will do a quick spot-check on completion and release payment on...

Overview I turn your raw sales records into a clean, interactive Excel dashboard. You can see how the business is performing at a glance and filter by month and product category, without any manual calculation. What the dashboard shows Key figures: total revenue, number of invoices, units sold, and average invoice value Monthly sales trend: a line or column chart Sales by category: a chart showing which categories earn the most Top 5 products and top 5 customers: auto-updating ranked tables Filters: month and category slicers that update every figure and chart at once Deliverables One .xlsx workbook with a Data sheet, a Calculations sheet, and a Dashboard sheet Your existing sales data cleaned and set up as an Excel Table, so new rows are picked up automatically A one-page instruction ...

I need ongoing help keeping my customer data workbook clean, accurate, and up to date every single day. The dataset grows continuously, so I rely on a freelancer who can jump in, understand the structure quickly, and handle three core activities without constant supervision: • Data entry – capturing new customer records from source files or emails • Formatting and sorting – keeping columns consistent, removing duplicates, applying filters for quick look-ups • Applying basic Excel formulas – totals, averages, lookups, and error checks to flag any anomalies Each workday you’ll receive the raw inputs, update the master file, and return the refreshed version (or sync it in a shared drive) before the agreed daily cutoff. Consistent accuracy is cru...

I need help recovering an Excel file that won't open. I've already tried using Excel's built-in repair tool without success. Ideal Skills and Experience: - Expertise in Excel file recovery - Experience with data recovery tools and techniques - Familiarity with handling corrupt Excel files

I have a steady flow of digital information and PDF files that must be turned into clean, well-structured Word reports and concise Excel sheets. The work is threefold: • Convert PDFs to fully editable Word documents. • Enter data pulled from digital sources into Excel with zero transcription errors. • Polish each report so it follows a single font/style set and includes an automatically generated table of contents. Microsoft Word, Excel, and any reliable PDF conversion tool (Adobe, Nitro, etc.) will be essential. Accuracy, careful adherence to my instructions, and on-time delivery are more important than sheer speed. When you reply, please let me know: – A brief example of similar PDF-to-Word or data entry projects you’ve handled. – Your ty...

I need a clear, well-structured costing sheet in Microsoft Excel that lets me calculate every expense that goes into a tour package here at our DMC in Muscat, Oman. The workbook has to capture the full range of cost elements I deal with every day—accommodation, transportation, meals, guide charges, plus any third-party or other outsourced services—while still being easy enough for the reservations team to update quickly. Key points I want built in: • Separate input areas for each cost component with automatic subtotals • A consolidated summary that rolls everything into a single “tour cost” figure • Space for markups or margins so I can see net versus sell price at a glance • Currency flexibility (our suppliers bill in both OMR and USD) ...

I need several scanned PDFs turned into perfectly matched Excel workbooks. Each source file contains images of tabular data, so solid OCR skills alone are not enough—I also expect meticulous manual proof-reading to guarantee zero transcription errors. You may use Adobe Acrobat Pro, ABBYY FineReader, Tesseract, or any other combination of tools, as long as the finished spreadsheets reproduce the original layout, numerical values, and text exactly. Deliverables • One .xlsx file per PDF, named to mirror the original • 100 % text and number accuracy, including headers, footnotes, and currency symbols Acceptance criteria • Random spot-checks show no discrepancies • Column order and calculated totals match the scan precisely If you have a proven track record...

I have an existing workbook that needs a set of well-structured, reusable formulas so I can run quick calculations without relying on manual edits. At this stage I’m still finalising the exact datasets and worksheet layout, so your formulas should be written in a way that can easily be adapted to either a single sheet or a multi-sheet setup. The data itself may range from pure numbers to mixed alphanumeric values, so the logic must account for different data types and avoid errors when a cell contains unexpected content. Nested functions, dynamic named ranges, array formulas (or their Office 365 equivalents), and clear in-cell documentation are all welcome if they keep the workbook lean and easy to audit. Once the formulas are in place I’ll test them against several sampl...

I need an Excel expert to create several formulas for a spreadsheet. Essential Requirements: - Ability to perform mathematical calculations, including basic arithmetic, statistical functions, and financial calculations. - Experience with text manipulation functions. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong analytical skills - Experience with complex formulas and functions - Attention to detail Please provide examples of previous work.

I need an Excel template that makes it quick and fool-proof to log our revenue. The sheet will only capture sales amounts, and every entry has to be automatically tagged by product or service so I can slice totals instantly. Core requirements • Simple, protected entry form for daily sales amounts • Drop-down list (or similar) that forces the user to choose the correct product/service category on each line • Behind-the-scenes table structure that keeps raw data clean for future pivot-table or Power Query use • A summary tab that rolls up total revenue per product/service and refreshes with one click I’m happy with native Excel functions—no external add-ins needed—as long as the workbook stays compatible with Microsoft 365.

I’m putting together a three-sheet Excel workbook to help me stay on top of my money and I’d like a specialist to build it cleanly so everything updates automatically. Sheet 1 – Income & Expenditure I want a straightforward table with separate columns for income and expenses. As I add rows, running totals and a net-balance field should refresh instantly. Simple drop-downs for date and category would be a bonus, but clarity and ease of data entry come first. Sheet 2 – Statistics Here I only need bar charts that pull from the first sheet and redraw themselves as new figures appear. At a glance I should be able to compare monthly totals and see trends. Sheet 3 – Budgeting (50/30/20) This sheet should apply the classic 50 % Needs, 30 % Wants, 20 % Sav...

I need help transferring and cleaning a set of mixed data that is already sitting in several Microsoft Excel workbooks. The job is straightforward: open the existing spreadsheets, copy-or-move the text and numerical fields into a new, consolidated Excel file I will provide, and make sure each column aligns with the schema I’ll share at kickoff. You may have to adjust a few formats—dates, currency, and text case—so the final sheet is consistent and import-ready for a later process on my side. You’ll be working only in Microsoft Excel, so please be comfortable with common functions like VLOOKUP/XLOOKUP, text-to-columns, conditional formatting, and basic data validation. If you prefer macros or Power Query to speed things up, that’s fine as long as the end resul...

An existing Excel workbook is starting to slow down reporting because the raw data was compiled from multiple sources. The file now needs a proper clean-up and a consistent structure so I can use formulas, pivot tables, and dashboards without fighting errors. Here’s the scope in plain terms: the entire sheet must be reviewed, obvious problems removed, and every column normalised to the same format. That includes spotting anything that stops sorting, filtering, or lookup functions from working smoothly—mis-typed values, stray spaces, mis-aligned dates, hidden characters, or anything else you notice while you work. If a lightweight VBA routine or Power Query step will save time, feel free to use it; the final file just has to open in standard Excel without external dependencie...

I keep all of my customer information in one Excel file that is starting to sprawl across several worksheets. What I want is a single-entry workflow: I type a customer’s name or code once and the file instantly pulls the relevant details from the various sheets, then produces a clean, printable quotation (and, later, an invoice version) with no extra copy-and-paste steps. The solution can be built with VBA, Power Query, dynamic arrays—whatever is most robust—but it has to meet three essentials: • Pull linked customer data from multiple sheets in the same workbook. • Populate a quotation template automatically, ready for PDF or direct print. • Leave me with a user-friendly front end so anyone on the team can generate quotations without touching the underlyi...

I have a collection of records that need to be keyed into Excel manually. The information is a mix of text and numbers, so the workbook has to be arranged in a way that keeps labels clear while still allowing basic calculations or filtering. I do not yet have a working template, only a rough idea of how the finished sheet should look. Your first task will be to shape an easy-to-use layout—column headings, consistent data types, light formatting, and, where it makes sense, simple formulas or data-validation to prevent errors. Once the structure is approved, you’ll enter all of the supplied data with careful attention to spelling, number accuracy, and overall consistency. Deliverables • A reusable Excel template (.xlsx) reflecting the agreed layout • The template ...

I have a set of raw figures that I need entered accurately into a master Excel workbook and, just as importantly, I want the file to do the heavy lifting for me once the numbers are in place. This means building solid formulas—SUM, SUMIF/S, XLOOKUP, IF statements, running balances, variance percentages—so the totals and subtotals update automatically every time I add new rows. Accuracy is critical because these tallies feed straight into management reports. If you spot a cleaner way to structure the sheet or streamline calculations, I’m open to your suggestions as long as everything remains transparent and easy for me to maintain. Deliverables • A clean .xlsx workbook populated with my supplied data • All requested formulas working and tested with sample v...

I have an Excel workbook that needs to do more than hold raw numbers. Using IF, SUMIF (and similar) formulas, I want the file to: • filter my data on the fly, • run conditional calculations that adapt as new rows appear, and • roll everything up into clear, criteria-based summaries. Once that logic is solid, I also need a one-click way to export the relevant sheets—or a defined print range—straight to PDF. The export should preserve whatever structure the formulas create, so the numbers shown in the PDF always mirror the latest workbook state. If charts or additional tables are required to make the report clearer, please build those into the flow; I’d like the option to toggle them on or off without touching the underlying code. Deliverables: ...

I have several spreadsheets of raw sales transactions pulled from different systems. Before the numbers feed our dashboards, I need one consolidated file whose figures I can trust. Your job is pure data cleaning and validation—no manual re-keying—focused entirely on verifying the accuracy of the sales data already in place. Here is what I need from you: • Examine every column (dates, order IDs, SKU codes, quantities, prices, tax, totals) and confirm each record is internally consistent. • Recalculate extended prices and grand totals with formulas to catch calculation errors or missed tax. • Cross-check SKU codes against the master product list I will supply; flag any that don’t match. • Identify and clearly mark blank or suspicious values tha...