Visual Basic untuk Aplikasi Jobs

I am putting together a comprehensive inventory-management report that draws on several different raw data sources and I need your help building it in Advance Excel, enhancing it with Macros/VBA automation, and visualising the results in Power BI. Here is what I have in mind. Multiple CSV and spreadsheet feeds will be consolidated, cleaned and reshaped inside Excel. Macros or VBA routines should automate the refresh and mapping process so I can drop new files into a folder and have the workbook update itself without manual intervention. From there, the prepared tables need to flow into a Power BI model that produces an at-a-glance dashboard highlighting current stock levels, inbound and outbound movements, and any exceptions that require action. I will supply sample data so you can design...

I have an existing Excel workbook that I use for staff rostering. At the moment every step is manual, so I want the entire process wrapped into one push-button VBA routine. When I click the button the macro should: • Allocate each employee to the required shifts • Detect any conflicts such as overlapping hours or breaches of contracted limits • Check every assignment against the applicable awards and internal policies, preventing non-compliant rosters from being published The file is already structured; your job is to build the automation logic, wire it to a clearly labelled button, and return a macro-enabled workbook (.xlsm) that produces the finished roster on demand. Please comment the code so I can maintain it later and include a brief note or screen recording th...

I need an Excel workbook enhanced with VBA that can pull sales data directly from our database, crunch the numbers automatically and present clear, on-demand reports. The focus is pure analysis and reporting—no manual copy-pasting, no repetitive filter steps—just hit a button and the figures are there. Here is what I’m after: • A reliable VBA routine that connects to the database, refreshes the data set, and stores it in well-structured worksheets. • Automated calculations for common sales KPIs—revenue by product and region, period-over-period growth, averages, and any additional measures you suggest that add quick insight. • Polished summary views (pivot tables or a lightweight dashboard) that update whenever the refresh runs, so management can ...

Necesito agilizar un proceso interno llamado MTM. Hoy lo ejecuto manualmente y pierdo demasiado tiempo en: • organizar datos • realizar cálculos complejos • generar reportes de salida Quiero que todo eso ocurra con un único clic desde un botón incrustado directamente en la hoja de Microsoft Excel. Alcance inmediato (entrega en 1-2 días): 1. Revisar conmigo el flujo actual de MTM para identificar qué pasos pueden convertirse en código VBA sencillo. 2. Crear las macros necesarias que automaticen los tres puntos anteriores sin alterar la estructura de mis archivos. 3. Insertar un botón visible y descriptivo dentro de la hoja que dispare todo el proceso. 4. Probar la solución con un pequeño set de datos y a...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

Projet : Automatisation de la Conception de Guides Genou 3D Ce projet vise à automatiser plusieurs étapes critiques du flux de traitement d'un cas de genou 3D, spécifiquement axé sur la conception de guides orthopédiques. L'objectif principal est de réduire la variabilité, d'améliorer la robustesse, d'accélérer les délais et de minimiser les erreurs humaines. Les défis incluent la gestion de différents formats de fichiers (STL, SLDPRT), la création de géométries de référence spécifiques à chaque client, l'assemblage précis de pièces, la conception paramétrique de guides, l'application d'inscript...

I already have an Excel system with a Measurement Sheet (input) and Dashboard. I need a small automation to generate an RA Bill sheet automatically from the measurement data. Requirement: RA Bill should be generated automatically based on the selected RA number. Each Item No. should appear as a heading with its BOQ description. Under each item, the measurement rows should appear automatically from the Measurement Sheet. The table should have these columns: Description | Unit | N1 | N2 | Length | Width | Depth | Qty The Description column should show location/sub-item from the measurement sheet. When entries for the same Item No. end, the system should automatically show Total Quantity. After the total row, the next Item No. section should start automatically. The number of rows under each ...

I’m looking for an expert who can install the necessary components for automating and scripting workflows between Excel and OneNote, then walk me through how everything works. My priority is getting the automation up and running smoothly, followed by clear, hands-on training so I can maintain or adjust it myself later. Deliverables • Fully installed and configured automation solution connecting Excel and OneNote • Live training session(s) showing how to run, modify, and troubleshoot the scripts • Quick-reference documentation or a short recording summarising the key steps and best practices If you’ve built similar Excel-to-OneNote automations before and enjoy teaching, I’d love to hear how you would approach the setup and training.

All of our production figures are already captured in a single Excel workbook; what I need now is a clear, interactive dashboard that turns those raw rows into insight. The layout should feature bar charts, pie charts, and line graphs so supervisors can see at a glance where we stand. Key metrics are straightforward—total production volume and accumulated downtime—updated automatically each day as fresh data is entered. The solution must sit entirely inside Excel (Power Query, PivotTables, dynamic arrays, or light VBA—use whichever combination keeps the file fast and maintenance-friendly). A single click refresh is plenty; real-time streaming is not required. Deliverables • One dashboard tab with the visualisations laid out cleanly for shop-floor display • A...

I have a raw customer information dump that needs to be cleaned up and structured in a single Excel workbook. The spreadsheet must include the following fields for each record: • Name and address • Email and phone number Once the data is validated and entered, I want every row assigned to a clear category column that identifies the customer type, so the final sheet can be quickly filtered or reported on. Simple Excel formulas such as CONCAT, TRIM, and basic IF statements should be used where they save time and improve consistency; however, there is no need for advanced macros or VBA. Accuracy is critical—I will be cross-checking a sample of the finished data before sign-off—so please double-check spellings, spacing, and the integrity of any formulas you add. I&...

I have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me. Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly. Deliverables • The updated workbook with the automation in place • A short note...

Necesito una macro para CorelDRAW que tome los vectores y grupos de objetos que yo seleccione y los reubique dentro de un rectángulo que yo mismo defina, aprovechando al máximo el espacio disponible sin que se superpongan. Requisitos clave • Funcione con vectores y grupos de objetos de cualquier tamaño. • Pida o permita introducir las dimensiones del área destino. • Calcule automáticamente la mejor distribución posible (similar a un “auto-nesting”), manteniendo proporciones. • Respete un margen configurable entre objetos y, de ser posible, permita rotación a 90° para ganar espacio. • Interfaz sencilla: botón o acceso directo dentro de CorelDRAW para ejecutar la orden en un solo paso. ...

I already have a working Excel workbook in daily use, but its current macros are slow, brittle, and hard to maintain. I need an experienced VBA developer to dive into the existing code, streamline the logic, and add any missing functionality so routine tasks run reliably at the click of a button. Although the immediate scope is limited to Excel, I would like the code written cleanly enough that it could later be adapted for Access or Word–based reporting if the project grows. After an initial review of the file, we can agree on the exact touch-points, but my priorities are: • Refactor or replace outdated VBA modules • Optimise speed and eliminate manual steps wherever possible • Add clear in-line comments and a brief user guide sheet • Leave the workbook f...

I need to embed practical AI features directly inside Outlook, Word, and Excel so my day-to-day work becomes far less manual. Primary goals • Tame email overload in Outlook by automatically triaging, categorising, flagging priorities, and suggesting quick replies. • Speed up document creation in Word with smart templates, content suggestions, and live error-spotting that adapts to our writing style. • Simplify scheduling and calendar management across the suite—auto-generate meeting slots, resolve conflicts, and surface insights on time allocation. Key capabilities to build – Automation of repetitive tasks: rules or add-ins that run without constant supervision. – Data analysis & insights: lightweight dashboards or side-panes inside Exce...

I have three Excel workbooks whose VBA-driven macros used to handle a handful of quick calculations and automated steps for my students. Those functions have stopped running altogether—no errors, just macros that refuse to fire—so first I need the existing code reviewed, debugged, and restored to full working order. Once everything works flawlessly in Excel, the same functionality has to live inside Google Sheets. After you tidy up the VBA, please translate it into clean, well-commented Google Apps Script, embed it in a Sheets copy of each file, and make sure the buttons or menu items behave exactly as they do on the desktop. Deliverables • Repaired VBA across the three original worksheets • Change log or in-line comments explaining what you fixed • Google ...

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 have a set of raw survey results that I need prepared for deeper analysis. The core task is data cleaning inside Excel: removing duplicates, handling blank or inconsistent entries, normalizing date or rating formats, and making sure every column is analysis-ready. Once the file is cleaned I should be able to drop it straight into pivot tables or statistical add-ins without further fixes. Please keep all original fields intact, add a clearly labeled “Cleaned” worksheet, and document any transformation rules you apply in a small notes tab so I can audit or tweak them later. If you have VBA routines, Power Query tricks, or other proven Excel techniques that speed up repeat cleaning, feel free to use them—the deliverable just needs to stay within the Excel environment...