Vba as400 iseries jobs

I need VBA script to execute stored procedure that I have in oracle SQL with some parameter input from excel

I have a spreadsheet holding names, emails, phone numbers, and company addresses for 500 firms. Everything is already there and already separated into columns—I simply need it turned into a clean, presentation-ready contact database. Your task is to: • open the existing Excel file ...obvious typos • normalise phone numbers to one format and make sure every email cell is recognisable by Excel as an email link • flag any duplicates you notice so I can decide what to keep • return the finished workbook in .xlsx No data scraping or research is required; it is pure formatting and quality control. If you prefer to handle the touch-ups with formulas, Power Query, or a quick VBA routine, that’s fine—as long as the final sheet is tidy, uni...

...compares actuals vs. plan and flags variances automatically. • Valuation outputs—DCF, multiples, and scenario-sensitive sensitivity tables—presented in a concise summary tab that I can drop straight into a pitch deck. • Clear, commented formulas in Excel (or Google Sheets) so future edits are painless, plus a brief walkthrough video or PDF that explains the logic. If you prefer Power Query, VBA, or even a lightweight Python script to automate data pulls, feel free to suggest it—efficiency matters as long as the final deliverable remains easy for non-technical stakeholders to use. Acceptance criteria: numbers reconcile down to the last cent; sensitivities recalculate without error; and every assumption is both traceable and editable in one place. ...

...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...

...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...

...of mixed text and numeric fields. My aim is to identify and flag records that are not exact duplicates but close enough to be considered the same customer, product, or transaction. In other words, I need a reliable fuzzy-matching solution that surfaces these near-matches so I can review and consolidate them. Here is what I need from you: • A working Excel-based approach—formulas, Power Query, VBA, or a combination—that compares the mixed fields and returns a similarity score or direct match flag. • Clear, editable logic so I can tweak thresholds or add new columns later without rewriting the whole thing. • A brief walkthrough (written notes or short screen capture) showing how the matching was set up and how I can re-run it when new data arrives. ...

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 have several Excel workbooks of 150,000 + rows containing names, job titles and email addresses. I need a VBA macro that can comb through the Job Title column, spot rows whose titles match a set of keywords that I will provide, copy those rows (or just the email addresses—your guidance is welcome) into a brand-new worksheet, and leave the source data untouched. Key requirements • Source files are always in native Excel format, so you can rely on worksheets, ranges and tables rather than import code. • The solution must handle both a one-click manual run (e.g., a ribbon button) and an automatic mode that fires when a file is opened or dropped into a folder. • Performance matters: even on 150k rows the scan and copy should feel snappy, so efficient loopin...

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

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

I need a clean, well-structured Excel file that will hold and organise my financial data. The workbook should be laid out so new entries flow in exactly where they belong and key numbers update automatically. On top of that, I want each re...into the Excel workbook (or a synced Google Sheet that feeds the workbook). • With one click, a macro or script places the chosen record into a pre-formatted Word file—totals, dates, notes and all—ready for download or email. The final deliverable is the finished spreadsheet, the Google Form–to-Excel link, and the automated Word export function. It should run smoothly on current Microsoft 365; VBA or Power Query is fine as long as it’s reliable. Clear instructions on how to add new fields in the future would be th...

I need a developer experienced with AS400 systems to create an ACH file for supplier payments in NACHA format. The ACH files should be generated weekly. Key Requirements: - Extract payment data from AS400 - Format data into NACHA compliant ACH file - Automate weekly generation and delivery of ACH files Ideal Skills: - Proficiency in AS400 systems - Experience with NACHA file format - Background in payment processing and file automation

I need an Excel automation expert to set up a system that filters data based on specific text criteria and copies it to a new workbook. The filtering and copying should be triggered by a button click....up a system that filters data based on specific text criteria and copies it to a new workbook. The filtering and copying should be triggered by a button click. Key Requirements: - Apply text filters to Excel data - Automatically filter and copy data to a new workbook - Action triggered by a button click Ideal Skills and Experience: - Proficiency in Excel, especially with automation tools like VBA - Experience with setting up button-triggered actions in Excel - Attention to detail and accuracy in data handling Looking for a freelancer who can deliver a clean, functional solution ef...

I’d like a streamlined Excel tool that lets me generate instant cost estimates for flyer jobs in my printing press. The sheet should prompt me for key variables—paper type, quantity, print quality, freight...Behind-the-scenes formulas that add mark-ups, combine fixed and variable costs, and flag any negative margins • An easy-to-read summary section showing subtotal, tax (if I toggle it on), and final figure If you can add optional dropdowns for common paper stocks and a printable quotation sheet, that’s a plus. Please send a detailed project proposal explaining your layout concept, key formulas or VBA snippets you’d use, and an example of a similar cost calculator you’ve built. I’m ready to choose quickly once I see a plan that keeps d...

I need an Excel feature that adds a "+" button to duplicate both rows and columns of a sheet. The duplicated parts should maintain their original formulas and values. Requirements: - Excel proficiency - Experience with VBA or Excel macros for customization

...our online database and instantly return both customer and project details. When a match is found, the form should auto-populate the relevant cells; when no match exists, every field must remain editable so I can type the information in myself from scratch. The workbook is already on OneDrive, so please design the solution to run smoothly there, whether you choose built-in Excel Forms, a bit of VBA, Power Query, or a lightweight Office Script—whichever you feel is most reliable for cloud use. Key fields will include project ID, customer name, address, phone, project description, and status. All lookups reference our SQL-based database via its standard connection string, which I will provide. Deliverables • A working form embedded in the same workbook • Conne...

I need an Excel workbook that lets me record everything that happens in the shop each day and then spits out a clean date-stamped PDF summary at the click of a button. For the sales section I will type the user name, the sale amount and whether it was Cash or Credit; the sheet should total both ...calculate daily totals for cash sales, credit sales, expenses and credit payments • show the net cash position for the day (cash sales + credit payments – expenses) • let me pick the report date from a drop-down or calendar and then generate a neatly formatted PDF summary after I press a “Create Report” button Please build this with standard Excel functions and, if needed, a small, well-commented VBA macro to handle the PDF export so it works on any recent...

...Expected Processing Logic (Power Query) The solution should: • Use Power Query to ingest all source Excel files from a shared OneDrive folder • Clean, standardize, and validate data (dates, truck numbers, depot names) • Link datasets using: o BL Number o Truck Number o Trip / Load ID o Customer / Order reference • Produce clean fact and dimension tables suitable for later migration to Power BI • Avoid VBA and Excel-only logic All transformation logic should be documented and reusable. 4. Dashboards & Outputs 4.1 BL & Hospitality Overview • Active BL list Hospitality expiry countdown • Volume lifted vs remaining per BL • Vessel and consignee visibility 4.2 Fleet Journey Status (Long Haul) • Truck count by journey segment: o Dar...

...the raw figures in the cells. Key points you should know • Update trigger: only when a new URL is pasted or an existing one is edited. No recurring cron jobs needed. • Invalid URLs: if the link is broken or not an Instagram post/Reel, the cell should immediately display a clear error message so I spot issues at a glance. • Environment: I am flexible—Google Sheets (Apps Script), Excel with VBA, or a lightweight Python script that writes back into the sheet through an add-in or API would all work. Use the method you are most confident will stay stable with Instagram’s current endpoints. • Rate limits & log-ins: please handle any authentication or token requirements internally so I only need to paste the link and see the numbers. Deliver...

...in a OneDrive-hosted workbook. In my main reporting file I want a table that refreshes automatically, pulls in only the rows whose transaction dates fall between two cells (StartDate and EndDate in the report), collapses duplicate product lines into a single row, and adds their quantities together. Please build this entirely in Microsoft Excel. Power Query seems the natural choice, but a clean VBA routine is fine if it meets the same “one-click / on-open” refresh behaviour and continues to work when the file is synced through OneDrive. Core expectations • The path to the external workbook must stay dynamic so it continues to resolve once OneDrive assigns it a cloud URL. • Changing either of the date-range cells must be enough to make the summary re...

I need a experienced Sage 300 developer to help me modify a couple of VBA macros, and to modify the logic on a customised application. These are small projects to be used as a testing ground for larger projects should the results and working relationship be successful.

My multi-sheet inventory workbook has stopped behaving: data no longer cascades from the entry tabs to the summary pages, several formulas now throw #REF! and #VALUE! errors, and the stock-on-hand totals are clearly off. I need the entire calculation flow traced, the break points isolated, and every formula rebuilt so that ne...reorder levels, and valuation figures update automatically the moment data is entered • No #REF!, #VALUE!, or circular reference warnings remain • All named ranges and tables are correctly scoped and documented in a “Changes” tab for future maintenance Excel’s native functions should do the heavy lifting, but feel free to streamline with structured references, dynamic arrays, or lightweight VBA if it keeps the file fast and tr...

I have a small Microsoft Access table of prices—roughly 250 records—that I want turned into a streamlined quoting tool for our sales team. From a single, well-designed form...clean look the customer sees on the final document. Acceptance criteria • Search returns correct record(s) instantly by item name or part number • Quantities multiply against unit prices accurately; totals calculate without rounding errors • One-click export to .docx and .pdf with all branding elements in place • Editable notes field saved inside each quote file • Source file (Access, VBA, or chosen tech) and any supporting scripts delivered, fully documented Once finished the tool will let every salesperson generate and email standardized quotations instead of p...

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.

...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...

...Operating expenses Personnel Automatically flows into: Revenue projections Expense schedules Capex & debt schedules Depreciation Integrated financial statements Dashboard outputs The model must be intuitive for non-Excel-expert partners. Core Requirements 1. Architecture Clear separation of Inputs, Calculations, and Outputs Structured tables (no fragile row references) No unnecessary VBA No hardcoded cross-sheet values Clean sign conventions Scalable timeline 2. Financing Logic Dropdown-driven financing classification: Rent to Own / Operating Lease → Operating Expense Capital Lease / Purchase → Capex + Debt + Depreciation Must automatically flow through the model. 3. Financial Statements Fully integrated: Income Statement Cash Flow Statement...

Gemini said To get the best results from a freelancer (on sites like Upwork or Freelancer.com), you need to be very specific about the "Many-to-Many" issue you mentioned. Here is a clear, ...Deliverables: Input Sheets: Two formatted tables (one for PO, one for GRN) where I can paste new data daily. Summary Dashboard: A Pivot Table or Power BI-style view in Excel showing a summary per Voucher No. Detailed Report: A line-by-line comparison showing exactly which items or taxes don't match. Technology: I prefer a solution using Power Query (to handle the many-to-many relationship) or VBA/Macros for a one-click refresh. Ideal Freelancer: Expert in Excel Power Query and Data Modeling. Experience in Accounting or Supply Chain reconciliation. Ability to create a clean,...

...require thorough data entry focused on cleaning and validation. Every figure must be double-checked for accuracy, inconsistent formats need standardising, and any duplicate or obviously erroneous records have to be flagged and fixed. You will be working directly in the existing Excel files, using whatever techniques you find most efficient—formulas, filters, conditional formatting, even light VBA if that speeds things up—as long as the final sheets remain fully functional and easy for me to audit. Deliverables • A clean, validated version of each original spreadsheet, preserving all columns and row order • A brief log (can be a separate tab) noting the corrections made, the rules you applied, and any outliers that still need my review Acceptance c...

...long-standing Excel workbook (now running in Excel 2019) contains a VBA routine that has reliably processed then pushed both Excel and PDF reports up to our FTP directory for the past nine years. Last month the upload stopped working. It now tries to upload a file to FTP but the file size it is zero. There are a couple of options I can run, one uploads 2 files, the other can do lots more but when I run it only 1 files tries and again the file size is zero; nothing in the FTP server settings has changed, and credentials still test fine through FileZilla, so the issue appears to be inside the spreadsheet or its supporting script. I did change a few items on the spread sheet but I thought I had changed them back. I need you to dive into the VBA, diagnose why the macro no lon...

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

...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...

...motorcycle as unavailable for overlapping dates. • Store every reservation in a permanent log that I can filter by bike, customer name, or date range, so I can review usage patterns or settle disputes later. A clean front end (forms, drop-downs, or slicers) is important because different staff members will be using it each day. Behind the scenes you’re free to rely on formulas, tables, Power Query, or VBA—whatever delivers quick automatic availability updates and a reliable, searchable booking history without corrupting the data. Acceptance criteria – Adding or editing a reservation instantly refreshes availability for all motorcycles. – The booking history keeps an untouchable audit trail; deleted or overwritten entries are impossible. &nda...

I’d like an Excel-based workbook that lets me log sales and expenses for my retail operation and instantly see my profit or loss. The file should do more than just total columns—I need meaningful sales an...best-selling items, daily/weekly revenue, and margins. • Built-in expense categorization so I can filter or pivot by cost type. • All formulas locked from accidental edits, with a brief “how-to” tab explaining where to input data and how to refresh reports. I’m fine with standard Excel functions, Power Query or light VBA—as long as everything runs inside a single workbook and works on current Microsoft 365. Please deliver the finished .xlsx (plus macro-enabled version if VBA is used) populated with a small set of sample da...

...storage—or a stand-alone battery bank—makes financial sense for a client. The template must stay friendly for non-technical users: a single “Inputs” sheet where they enter only the basics (system size, quoted purchase price, expected annual production or throughput, tariff information, and a couple of simple assumptions). Behind the scenes the file should run the heavy lifting with clear formulas or VBA, but the visible experience remains tidy and intuitive. Key financial drivers we must cover are up-front investment cost and the ongoing value of energy saved or shifted. Maintenance can sit outside the scope for now; if you prefer to leave a placeholder column that’s fine, but it should not confuse the end user. Because general clients will be read...

...alerts—colour-coded and, ideally, a pop-up or email trigger when a threshold is crossed • Detailed summaries: current balance by size/BF/GSM, monthly usage, ageing stock, and a concise “Order Now” list I will be entering data manually, so friendly forms or dropdown menus for size, BF and GSM will help prevent typing errors. Behind the scenes you can rely on dynamic tables, Power Query, pivot charts, or VBA—whatever produces a fast, maintenance-light file. Acceptance criteria: 1. Dashboard sheet instantly reflects any new inflow or outflow. 2. Reorder triggers and thresholds are easy for me to change. 3. All calculations are protected from accidental edits yet stay transparent for future tweaks. Once tested on a week’s worth of my act...

Please Sign Up or Login to see details.

...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 • the PDFs reach the correct inbox with a short, editable email body Deliverables 1. The finished automation (macr...

...sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive in fully edita...

I want to streamline a repetitive drafting workflow by building a small suite of Python- and VBA-driven utilities that talk directly to our AutoCAD drawings. My first and most urgent need is an extractor that can open a folder full of DWG files, locate every tag ID drawn inside a rectangle, and return the raw data and accompanying metadata—plus the exact X,Y coordinates of every tag—into a clean Excel workbook. Once the core extractor is working, I also need the same script (or a companion VBA macro) to carry out a few housekeeping tasks automatically: • run validation passes that flag duplicates, impossible formats, or tags that are missing coordinates, • assign an unambiguous primary key so nothing clashes when we merge files later, • sepa...

I need Excel macros to automate data formatting tasks. Essential Tasks: - Primarily focus on automating repetitive tasks to save time. - Key area of automation is data formatting. Ideal Skills and Experience: - Proficiency in Excel and VBA - Experience in creating macros for task automation - Strong understanding of data formatting techniques - Ability to deliver clean, well-documented code Please provide examples of similar work done.

Project Title:Backtest Nifty 50 1-Hour Triple Supertrend Strategy with Options Execution Simulation Objective:I want a complete backtest of my positional strategy on Nifty 50 futures/options to evaluate performance, risk, and viability. The outpu...strategy performs well When the strategy performs poorly Deliverables in Excel or CSV format for all trades and metrics Include all calculations with clear column labels 5️⃣ Communication & Timeline Delivery Time: 7–10 days (negotiable) Regular updates are appreciated Freelancer should clarify doubts about entry/exit rules before starting 6️⃣ Skills Required Python / TradingView / Amibroker / Excel VBA Nifty 50 futures and options understanding Experience in backtesting technical strategies Ability to deliver clean, actionab...

...has to pull data directly from that source – no manual imports. Once connected, I’d like to slice and drill down into campaign performance, spot trends, and compare time periods at a glance. Here’s what matters to me: the layout must be clean and intuitive, KPIs should auto-refresh with one click, and underlying queries need to remain editable so I can tweak them later. If you prefer Power Query, VBA, or another Excel-native method to establish the link, that’s fine as long as it stays within the standard Office environment (no third-party add-ins). Deliverables • A single .xlsx file with a built-in connection to the database • Dynamic charts, slicers, and summary tables ready for daily use • A short set-up note showing where to adju...

...basic styling (date columns as dates, numbers as numbers, text wrapped where needed). Also send me the process and files so that I can test. Key points • 100 % coverage of all result pages on the site, not just a sample. • Output must be an Excel file with the cells pre-formatted for easy sorting and filtering. • Any scraping code or automation tool you build (Python + Selenium/BeautifulSoup, VBA, etc.) should be included so I can rerun the extraction when fresh results are posted. • If the site uses captchas, pagination or dynamic loading, handle those gracefully. • Keep the process compliant with the website’s terms of use. Deliverables 1. The completed, clean Excel workbook. 2. The runnable script or detailed steps you used. On...

...imports, refresh itself with one click, and immediately surface current sales, on-hand inventory, reorder points, and overall profitability. Visual clarity matters: colour coding that highlights exceptions, slicers for quick date or product filtering, and clean charts that resize well on most laptop screens. Feel free to build with PivotTables, Power Query, Power Pivot, dynamic arrays, or concise VBA—whatever delivers speed without bloating the file size. Please structure the workbook so that: • A hidden or clearly separated “Data” area holds raw inputs. • A protected “Dashboard” sheet displays the KPIs and charts only. • Key figures update automatically when new data are loaded. Deliverables • Finished .xlsx (and .xlsm...

...input values are changed. ### Scope * Create a working Excel chart solution using standard Excel functionality * Support a typical monthly dataset (Jan–Dec), but the setup should be easy to reuse * Ensure the color split follows the zero line dynamically (including transitions across zero) ### Technical preferences * **Formula-based solution preferred** (with helper columns/series if needed) * VBA/macros only if necessary (please explain why) * Clean structure so the file is easy to maintain and reuse ### Deliverables 1. Final Excel file (.xlsx) with chart fully configured 2. Short documentation (sheet note or comments) explaining: * where to enter/update data * how the chart works (at a high level) * how to reuse the template for another dataset ### Please...

...input values are changed. ### Scope * Create a working Excel chart solution using standard Excel functionality * Support a typical monthly dataset (Jan–Dec), but the setup should be easy to reuse * Ensure the color split follows the zero line dynamically (including transitions across zero) ### Technical preferences * **Formula-based solution preferred** (with helper columns/series if needed) * VBA/macros only if necessary (please explain why) * Clean structure so the file is easy to maintain and reuse ### Deliverables 1. Final Excel file (.xlsx) with chart fully configured 2. Short documentation (sheet note or comments) explaining: * where to enter/update data * how the chart works (at a high level) * how to reuse the template for another dataset ### Please...

...should cover • Automated price and margin calculations that recalculate as soon as cost data is refreshed • Seamless import of new product lists straight from our database (CSV or SQL export is fine) • Auto-generation of clean quote templates, ready to email or save as PDF • A clear, minimally manual correction path when a code is flagged Tech expectations Excel formulas, Power Query, VBA, Office Scripts, Python add-ins, or an AI to use whatever combination gets the job done accurately and fast. You’ll also be working with our existing product database, so familiarity with basic database management is important. Deliverables 1. Working Excel (or hybrid) solution with the IMPA validation, red-flag logic, automated calculations, and template ...

...input values are changed. ### Scope * Create a working Excel chart solution using standard Excel functionality * Support a typical monthly dataset (Jan–Dec), but the setup should be easy to reuse * Ensure the color split follows the zero line dynamically (including transitions across zero) ### Technical preferences * **Formula-based solution preferred** (with helper columns/series if needed) * VBA/macros only if necessary (please explain why) * Clean structure so the file is easy to maintain and reuse ### Deliverables 1. Final Excel file (.xlsx) with chart fully configured 2. Short documentation (sheet note or comments) explaining: * where to enter/update data * how the chart works (at a high level) * how to reuse the template for another dataset ### Please...

I'm looking for a VBA expert to help me automate the generation of reports in PowerPoint using survey results. Key Requirements: - VBA script to generate PowerPoint slides based on survey results. - Ability to handle large datasets and create structured, easy-to-read reports. Ideal Skills and Experience: - Advanced knowledge of PowerPoint and VBA. - Experience in data manipulation and report generation. - Attention to detail and ability to create professional-looking presentations. Please provide examples of similar work done.

VBA Excel expert required to fix errors in old code. You will need to step through the code with me on my computer to possibly change website address where Information is scraped from or fix errors in regard to the existing address. This Database has had several lives so there is lots of code in there that is no longer relevant so it could prove confusing without my input There are several points that will need fixing One of my scrapers is still working I did not write the code and don't know how to write code but i can view it and have a vague understanding of it. I believe that the webpages that i have scraped data from for many years has updated/modified something around 1 month ago (happens every few years) I use Internet Explorer to scrape the data (thi...