Visual Basic的应用程式 Jobs

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 need a streamlined VBA-driven workflow in Excel that lets me handle all incoming payroll data quickly and error-free, then produce a clean summary at the click of a button. The workbook must support three core activities: 1. Data entry – A simple userform for typing in one-off adjustments or new employee lines. 2. Data importing – A macro that pulls in weekly CSV exports from our time-clock system, places them in the right tables, and maps every column automatically. 3. Data validation – Rules that flag duplicate employee IDs, detect missing dates or rates, and stop bad records before they pollute the file. Once the data is in place and passes validation, I want a single “Generate Summary” control that produces an easy-to-read payroll summary (emplo...

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...