Visual Basic para aplicaciones Jobs

I’m compiling a growing set of sales figures and need a robust, user-friendly Excel workbook that lets me explore the data and quickly spot how different products, teams, or time periods stack up against one another. The core purpose is data analysis, with the immediate task centered on performance comparison. Here’s what I need the finished file to do: • Import or paste raw sales data without breaking anything • Auto-clean and structure that data (Power Query or similar approaches are welcome) • Generate dynamic summaries—pivot tables, slicers, and clear charts—that highlight performance differences by product, region, rep, and month • Refresh at a click so it scales as new sales rows are added • Include concise, in-sheet guidance ...

I need a single, well-structured Excel workbook that lets me type in basic transaction data—client name, due date, due amount, payment date, and payment amount—and have everything else happen automatically. As soon as I record a payment the sheet should deduct it from that client’s outstanding balance, update an overall running total, and flag any amounts still owed. Alongside the main data-entry table I want three report tabs that refresh themselves whenever new rows are added: a monthly financial report, a client-by-client payment summary, and an outstanding dues report. PivotTables, dynamic arrays, SUMIFS, or Power Query are all fine; the key is that I can click “Refresh” (or, even better, have it update automatically) and see the latest numbers without ...

I’m building a simple yet reliable system to log and analyze my trades, and I want the entire workflow contained in a single Excel file. The sheet has to let me enter trades in both the stock and crypto markets, capturing three fields only: the trade date, the ticker or symbol, and the profit or loss for that position. From there, the file should automatically calculate my running totals, my average profit or loss per trade, and the amount that I can gained or loss, and the percentage return so I can see how efficiently I’m trading over time. Please structure the workbook so data entry is friction-free—clean column headings, drop-down validation for asset type if helpful, and clearly separated summary metrics. All formulas need to be transparent and easy to audit; no hid...

I’m building a simple yet reliable system to log and analyze my trades, and I want the entire workflow contained in a single Excel file. The sheet has to let me enter trades in both the stock and crypto markets, capturing three fields only: the trade date, the ticker or symbol, and the profit or loss for that position. From there, the file should automatically calculate my running totals, my average profit or loss per trade, and the amount that I can gained or loss, and the percentage return so I can see how efficiently I’m trading over time. Please structure the workbook so data entry is friction-free—clean column headings, drop-down validation for asset type if helpful, and clearly separated summary metrics. All formulas need to be transparent and easy to audit; no hid...

I need an experienced Excel VBA developer to automate repetitive tasks. Ideal skills and experience: - Proficient in Excel and VBA - Experience in task automation - Ability to create and manage user forms - Knowledge of integrating VBA with other applications, especially Outlook and Access Please provide examples of previous work.

I want a tailor-made Excel workbook that helps me keep my personal finances under control. The focus is on Organização financeira, specifically Orçamento pessoal, with an emphasis on Acompanhamento de despesas. Here is what I have in mind: • A clean data-entry sheet where I can log each expense quickly, with drop-downs for category and payment method. • Automatic summaries that show how much I have spent per category, per week, and per month. • Visual cues—conditional formatting that alerts me when I am close to or over a preset limit. • A simple dashboard powered by formulas or PivotTables so I can spot trends at a glance. If you rely on Power Query for easy data import, dynamic named ranges for scalability, or a bit of VBA to s...

I need a streamlined Excel-based system that treats our service inventory the same way retailers track stock—only my “items” are scheduled maintenance jobs. Your task is to build and keep up a spreadsheet that shows, at a glance, every upcoming and completed maintenance task across the company. Here’s what matters most to me: • Each row represents a single maintenance task, clearly stamped with its status (pending, in-progress, done). • Filters and pivot-style summaries let me slice the data by location, equipment type, or technician without extra clicks. • Color-coded alerts highlight anything overdue or scheduled within the next seven days. I am already comfortable importing raw data from our service portal, so the workbook must accept eas...

I’m streamlining a series of files that live mostly as documents, yet the heavy lifting happens inside Microsoft Excel. I need an expert who can dive straight into my existing workbooks and build, refine, or replace formulas and functions so the sheets calculate everything accurately and automatically. What this involves • Reviewing the current layout and any sample data I provide • Designing clear, maintainable formulas—think look-ups, nested IFs, conditional sums, date math, or whatever logic the job calls for • Testing to be sure every cell returns the right result and scales as the data grows • Adding brief in-sheet comments so I (and anyone else who opens the file) can understand the logic at a glance I’ll send over the Excel files as ...

I’m refreshing the workflow for our advertising and merchandising arm and need solid Visual Basic coding to make it happen. The immediate goal is to build a clean, well-documented VB solution that automates how we track and prepare assets for an upcoming promotional video aimed at business clients. Source material, sample spreadsheets, and process maps are ready on my end—I’ve spent 15 years inside agencies, so expectations and edge-cases are already mapped out. Your code should slot into our existing Excel-based system, cut manual data entry, flag missing creative elements, and export a tidy report the editors can pull before they start cutting the video. Deliverables • Fully commented Visual Basic code (native VBA in Excel, VB.NET, or classic VB6—whic...

I’m looking to roll out a single Excel workbook—driven entirely by VBA—that will let my warehouse team record every kilogram of finished product that enters or leaves our godown. Each transaction must be captured against party, purchase order, batch, and current process stage, then stored in one normalized table so we never touch raw data again. Key flow • A clean user-form (no sheet scrolling) for data entry, validating quantities and dates before they hit the table. • Automatic posting of in- and out-movements, with running balances calculated product-wise in the background. • A daily summary report that refreshes with one click (or on open), showing the running balance for every product. Non-technical staff should be able to read it without hunting ...