Visual Basic pour les apps Jobs

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 need VBA script to execute stored procedure that I have in oracle SQL with some parameter input from excel

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

I’m working on an older 2011 copy of Microsoft Access and need a quick walk-through on how to locate specific words inside a single text-based table. This is a straightforward, basic search task—no VBA or complex macros—just the most efficient way to filter or query the records so I can spot every occurrence of a given term. If you know the built-in Find, filter, wildcard, or simple query features cold, that’s exactly what I’m after. A short screen-share or a clear set of step-by-step instructions that I can repeat later will do the trick. I won't pay a lot for this task. Please don't ask for more or I'll remove you.

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

I’m building a complete food-delivery solution for a restaurant client and need the full project taken from concept to App Store and Google Play launch. The app must run smoothly on both iOS and Android and include three core functions: • Real-time GPS so customers can pinpoint their address and track the courier’s journey • A secure payment gateway with Phone Pay fully integrated and tested • A QR-code scanner that lets diners view the live menu and place an order directly from their phone and also pay through their phones. Because I don’t yet have wireframes, the first milestone will be a full UI/UX pass—low-fidelity flows right up to polished, brand-matched mock-ups in Figma (or a comparable tool). Once those screens are approved, we move ...

My certificate template lives in a Word file that must be converted to PDF for each learner. Names, completion dates—and ideally their email addresses—sit in a single Excel sheet, and I want those columns to feed straight into the template in one sweep rather than by hand. The plan is to use that imported list, replace the placeholders, save every personalised certificate as <Name>, and fire off an email with the PDF attached—100+ times in just a few minutes, completely error-free. Any approach is fine—VBA mail-merge, Power Automate, a Python script, even Google Workspace—so long as: • the entire run can start with a single click on my Windows 11 / Office 365 machine • every PDF carries only the right learner’s name and date • ...