Visual Basic for Apps Jobs

Please Sign Up or Login to see details.

My current inventory spreadsheet has thousands of rows that need to be turned into a concise, interactive view so anyone on the team can spot key patterns instantly. The core task is to build, inside Excel, a robust pivot table (or connected set of pivot tables) focused strictly on data summarization of this inventory data. What I need from you is a clean-structured pivot solution that: • Refreshes flawlessly when new inventory records are added • Lets users slice results by any existing field (SKUs, warehouse, date received, etc.) without breaking formulas • Keeps the raw data untouched, with the summary living on a separate, well-labeled sheet • Includes clear, in-sheet notes so someone with intermediate Excel skills can maintain it later Please hand ove...

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

Dispongo de una hoja de OpenOffice Calc donde, en cada fila, una celda contiene la URL de la foto original de una prenda almacenada en mi servidor. Quiero un macro (VBA para OpenOffice Basic) que, apoyándose en cURL, tome esa URL directamente desde la celda, recupere la imagen y genere seis nuevas composiciones: 1. Prenda en modelo – vista frontal – ambiente rural 2. Prenda en modelo – vista frontal – ambiente urbano 3. Prenda en modelo – vista frontal – ambiente de playa 4. Prenda en modelo – vista posterior – ambiente rural 5. Prenda en modelo – vista posterior – ambiente urbano 6. Prenda en modelo – vista posterior – ambiente de playa Requisitos clave • El macro debe ejecutarse desde Calc...