Visual Basic for Apps Jobs

I have an Excel workbook packed with sales records collected from several sources and the date fields are all over the place—some are U.S. style, others European, some are stored as text, and a handful even show up as serial numbers. I need every date in every sales-related column brought into one clear, consistent format (ISO yyyy-mm-dd works well, but I’m flexible if you propose another). No other deduplication or formatting changes are required; the sole focus is correcting these date-format inconsistencies so the file is ready for reliable reporting and analysis. You’re free to tackle the job with whatever method suits you best—straight Excel formulas, Power Query, or a quick VBA macro—as long as the end result is rock-solid and reproducible. Deliverable...

I need a small, reliable routine that sits inside Microsoft Outlook and, the moment an email that matches my rules arrives, automatically pulls out both text and attachments and forwards—or otherwise pushes—that data to a single, predefined contact address. The goal is hands-free routing: no manual copy-pasting, no drag-and-drop of files, just seamless pickup and delivery every time. You may choose VBA, VSTO, an Outlook add-in, Power Automate (Flow) or another proven approach, as long as it runs locally in Outlook 2016/2019 and remains stable after Office updates. Error handling, clear logging, and a quick switch to enable/disable the rule are must-haves so I can troubleshoot or pause the process when needed. I’m working on a tight timeline, so readiness to start immedi...

I need a small, reliable routine that sits inside Microsoft Outlook and, the moment an email that matches my rules arrives, automatically pulls out both text and attachments and forwards—or otherwise pushes—that data to a single, predefined contact address. The goal is hands-free routing: no manual copy-pasting, no drag-and-drop of files, just seamless pickup and delivery every time. You may choose VBA, VSTO, an Outlook add-in, Power Automate (Flow) or another proven approach, as long as it runs locally in Outlook 2016/2019 and remains stable after Office updates. Error handling, clear logging, and a quick switch to enable/disable the rule are must-haves so I can troubleshoot or pause the process when needed. I’m working on a tight timeline, so readiness to start immedi...

I need a clean, future-proof Excel workbook built from scratch that turns my raw data into a clear Sales report while also keeping day-to-day inventory under control. Scope of work • Create a main Sales Report sheet that summarises daily, weekly and monthly figures—pivot tables and easy-to-read charts are welcome as long as they refresh with one click. • Add an Inventory sheet with: – automatic stock level updates driven by sales and purchase entries – visible supplier details beside each SKU for quick reference • Link both areas so any sale instantly adjusts inventory, safeguarding accuracy. • Keep formulas, named ranges and (if needed) VBA macros well-commented so I can tweak thresholds or add products later without breaking the mode...

I need a clean, interactive Excel dashboard that transforms my raw financial data into clear visuals so I can spot trends at a glance. The focus is strictly data visualization, not deep analytics, and the two chart types that matter for this project are bar charts and line graphs—nothing else is required. The workbook should let me drop in updated figures each month and instantly refresh the visuals. Think structured tables or PivotTables feeding dynamic charts, with slicers or drop-downs for quick period filtering. If Power Query or named ranges streamline the refresh, feel free to weave them in; just keep the file lightweight and easy to follow. Deliverables • One well-organized .xlsx file containing the dashboard, data source sheet(s), and all supporting formulas • A...

I have one (possibly two) Excel workbooks where many of the text cells contain multiple consecutive spaces inside the strings—think “New York” or “Invoice Number”. I do NOT need you to touch leading or trailing blanks; the goal is strictly to collapse everything inside the text so that any run of spaces becomes a single space. You may tackle this with a quick VBA routine, Power Query, an advanced Find-Replace sequence, or whichever method you prefer, as long as the result is accurate and repeatable. When you send the file back, every internal gap must be reduced to exactly one space, with all other content left untouched. Please return: • The cleaned workbook(s). • A brief note (or embedded macro) that shows the steps or code you used so I c...

I need a custom-built data analysis tool inside Excel that lets me load my raw spreadsheets, run predefined calculations, and see clear, organised results without manual copy-pasting or formula hunting. I already work in Microsoft 365, so the solution must sit comfortably in that environment and rely on native features such as dynamic arrays, Power Query, or VBA where they make sense. The core goal is speed and repeatability: once the logic is in place, I want to drop in a fresh data set, press a button (or refresh a query), and get the updated outputs instantly. If a lightweight dashboard sheet with charts emerges naturally from the workflow, that is a bonus, but the primary focus is robust analysis rather than visuals. Please tell me about your experience building similar Excel solutio...

I'm in need of an Excel expert with proficiency in VBA and macros. The primary tasks you'll be tackling include data analysis, reporting, and data manipulation on sales and inventory data. Key functions that the workbook should effectively perform includes: - Effective data analysis and reporting. Your prowess in Excel should ensure seamless interpretation and presentation of data. - Automation of data manipulation. Your skills should ease the process of handling large volumes of data, automatically organizing and adjusting it as necessary. - Specific calculations to provide inventory tracking and forecasting insights. Your expertise will help me make informed business decisions based on precise and timely data analysis. Proven experience handling similar projects would be adva...