Visual Basic для додатків Jobs

I have several Excel workbooks that need to start running themselves today. The goal is simple: turn my manual, time-consuming routines into push-button macros. The focus is on two areas: • Generating polished, ready-to-send reports from raw sheets • Cleaning and transforming data so downstream formulas, pivots, and dashboards work flawlessly Everything sits in Microsoft Excel and must be handled entirely with VBA. No add-ins or external tools are required—just clean, well-commented VBA modules that I can maintain later. I will provide the current files and a quick walkthrough of the reporting logic and data issues. From there, I need: 1. A single workbook (or a small set, if separation makes sense) containing fully automated procedures. 2. Clear triggers&mda...

I need an .xlsm workbook whose VBA macro fetches product data from both and lowes.com. When I type a valid item or model number into a row, the code should automatically pull back: product name, full description, regular price, sale price (if available), brand, product type/category, and the main image (inserted into the sheet or stored in an Image column). I work comfortably with VBA, so a concise, well-commented routine is all I need—no step-by-step user guide. The workbook must stay self-contained, relying only on standard references such as Microsoft XML, HTML, or WinHTTP libraries; please avoid external add-ins or Python bridges. Deliverables: • Finished macro-enabled Excel file (.xlsm) ready to test with my own SKU list • Clearly commented VBA code so I can...

I have an Excel workbook that already runs several VBA macros. Right now I need an extra routine added that, at the click of a button, builds an automated report containing clear graphs and charts drawn from the data that the existing code produces. Timing is tight—I will be online for the next two to three hours and would like to screenshare while you code so we can iterate quickly. Scope of the mini-upgrade • Insert a new sub or function into the current module stack that gathers the daily results, drops them onto a neatly formatted “Report” sheet, and then creates the required charts (line and bar are fine; feel free to suggest better visuals if you see fit). • Ensure the macro runs smoothly on both Office 365 and Excel 2016, without touching the pe...

I’m looking to streamline the way I track stock levels by turning a series of existing internal spreadsheets into a single, button-driven inventory report. Right now, the data sits in multiple Excel files that are updated daily by different team members; what I need is a routine—whether VBA macros, Power Query, or another native Excel solution—that pulls those sheets together, cleans the figures, and produces a polished inventory snapshot ready for management every morning. The core workflow I have in mind is simple: once the operator clicks “Generate,” your automation should gather the latest numbers from our internal workbooks, reconcile duplicates, highlight discrepancies, and output a formatted report (PDF and XLSX) showing on-hand counts, reorder points,...

My recruitment pipeline already lives in Excel; what’s missing is a hands-free way to turn that raw sheet into insight I can act on every morning. I need an Excel-based solution—whether it relies on formulas, VBA macros, Power Query, or a light Power Pivot model—that will automatically crunch the data I enter during the day and, by the next day, give me: • Daily Candidate Performance reports • Daily Recruitment Progress summaries • Daily Source-of-Hire breakdowns The reports should refresh with a single click (or on workbook open), capture any new rows I add, and present the metrics in a clean, printable format—charts or pivot tables are welcome as long as they stay linked to the underlying data. Clear documentation inside the workbook or a sh...

Necesito crear un app con la siguiente arquitectura: 1. Arquitectura de la Interfaz (UX/UI) La app debe tener dos modos: Modo Cliente y Modo Profesional. A. Pantalla Principal (Cliente) Buscador Inteligente: "¿Qué necesitás arreglar hoy?". Grilla de Categorías (Iconos grandes): Eléctrico, Plomería, Aire/Refrigeración, Albañilería, Cerrajería. Botón de Emergencia (Rojo): "Necesito a alguien YA". Al tocarlo, el sistema lanza una alerta a los técnicos disponibles en un radio de 5km que estén de guardia. Carrusel de "Recomendados": Profesionales con las mejores calificaciones de la semana en la ciudad. B. Panel del Profesional (Técnico) Switch de Disponibil...

I need a single Excel workbook that lets me see every project at a glance while still giving each project manager a personalised view. The opening tab will act as a master register containing all projects. From that master list, data should flow automatically into individual tabs—one tab per PM—so they only see the projects assigned to them. For every project I have to capture: • assigned project manager • employees on the job • core project details (name, client, start & end dates, status, and any notes) The current spreadsheet and additional details will be provided upon hire. Drop-downs, conditional formatting, simple formulas or Power Query should keep everything synchronised; use VBA only if it truly simplifies the workflow. The file should...