Visual Basic Jobs

I already have a partial VBA solution that pulls data from an Excel workbook and produces a quote in Word, however it needs a complete refresh. The goal is to end up with a single, well-structured macro that: • Adds new capabilities: picking only the components I mark in Excel, dropping everything else, and then merging the remaining data into one of my preset Word templates to create a finished quote. • Improves and streamlines the existing logic where necessary; parts of the current script are clunky and slow. • Fixes any run-time errors so the routine executes end-to-end without interruptions. Selection and omission must follow clear rules: primarily by component type, plus a small set of custom business rules that I will supply in a lookup sheet. As soon as the mac...

I need help with my MS Access database that has reached its 2GB limit and now I'm unable to add more data. Requirements: - Expertise in MS Access and Visual Basic - Experience with database management and optimization - Ability to troubleshoot and resolve data limit issues Ideal Skills: - MS Access proficiency - Visual Basic programming - Database optimization techniques Please provide a solution to restore functionality without losing any existing data.

I need a concise Power BI dashboard that zeroes in on our top-selling products. The core visual should be a bar chart that automatically ranks products by sales value and refreshes whenever the user changes the time-period slicer (month, quarter, year). The e-commerce dataset is already in Excel and includes order date, product name, category, units, revenue and profit, so you can focus on modelling and clear visual storytelling rather than heavy data cleaning. Please build the necessary DAX measures for total sales, units sold and profit, keep the layout minimalist, and rely only on native Power BI visuals so the report stays lightweight for SharePoint embedding. Deliverables • A single-page .pbix file that contains: – Ranked bar chart of top-selling products &ndash...

I am introducing quick-changeover (QCO) practices on our production floor and need a single Excel workbook that lets me see—at a glance—exactly which machines are Running and for how long. Each machine will be referenced by its unique Machine ID Deliverables • The finished Excel workbook, ready to plug in our machine list • A brief user guide (one or two pages) that shows supervisors how to add or modify Machine IDs and record a status change

I’ll be sending you a single workbook of Product sales data that is refreshed Monthly. Your first task will be to tidy up the existing tables—remove duplicates, correct obvious entry errors, and reshape the layout so every column is analysis-ready. Once the data is clean, I need clear answers to two questions: • Which products are the top sellers? • During which days of each month are they most frequently ordered? Please present your findings inside the same workbook. A small summary table with ranking logic is fine, but I would also like the insights visualised in charts so they are immediately understandable at a glance. Bar charts usually work best for product rankings and simple timelines, yet I’m open to other chart types if they convey the story bette...

I have a collection of raw numerical figures that need to be transcribed directly into Microsoft Excel. Accuracy is my highest priority, but speed matters too as I’m working against an internal deadline. Every value must be entered in the appropriate column and displayed with standard currency formatting so totals, subtotals, and future pivot-table summaries calculate correctly the first time. You’ll receive the source numbers as scanned sheets and a blank template workbook; simply enter the data, apply the currency format, double-check for transcription errors, and send the finished .xlsx file back. If a figure looks unclear, flag it in a comment so I can resolve it quickly. The assignment is straightforward—no macros or complex formulas—yet attention to detail i...

The production workbook I use in Excel needs a thorough clean-up and a few smart automations so it can keep pace with our shop floor. Here is what has to happen: • Strip out every redundant worksheet, button, or legacy control so the file opens lean and fast while still keeping the familiar look and feel we already use. • On the Material’s List tab, pull profile data automatically from every cut-list sheet, calculate the smallest possible panel count based on my preset width table, and make sure the sheet is perfectly formatted for printing. • Overhaul the DOOR Cut List: apply the current mix of standard sizing rules plus several custom exceptions I will provide, drive all dimensions from a single formula base, and add a one-click export that saves the finished cu...

I’ve finished building an Excel workbook and would like a fresh set of expert eyes on it before I put it into daily use. The data is already entered; what I need now is a careful pass to spot any hidden errors, streamline or confirm the existing formulas, and suggest small presentation tweaks that could make the file cleaner and more intuitive for end-users. Your deliverable is a revised copy of the file, accompanied by a short summary of everything you adjusted or confirmed. If you see opportunities for optional enhancements—such as a quick chart, a bit of conditional formatting, or a more efficient function—I’m open to them, provided they stay lightweight and don’t bloat the sheet. Accuracy and clarity matter most. Please let me know your estimated turna...

Necesito que transformes mis formularios clínicos en plantillas de Microsoft Word totalmente funcionales y fáciles de usar. Alcance principal 1. Crear cuatro archivos .docx independientes: • Historia médica • Órdenes médicas • Evolución médica • Informe de egreso 2. Automatización clave • Generación automática de informes: al completar la información en los campos de la historia, las órdenes o la evolución, el sistema debe reunir los datos y producir un informe final listo para imprimir o guardar en PDF. 3. Listas desplegables incluidas • Selección de diagnósticos • Selección de medicamentos •...

I need a clean, well-structured Excel workbook designed expressly for data analysis. The core requirement is a robust set of automated calculations and formulas that will let me drop raw data into defined input sheets and have the results populate instantly in the analysis tabs—no manual tweaking each time the dataset changes. Key points you should know: • The calculations must be transparent and easy to audit; please annotate any complex logic so I can follow the workflow later. • Accuracy and efficiency matter more than flashy visuals. Charts or import/export routines could become future add-ons, but for now the spreadsheet’s engine—the formulas—comes first. • I work in the latest Microsoft 365 environment, so feel free to use dynamic array fun...

I need a reliable hand to transfer a batch of text-based records into Microsoft Excel. All the information is already collected; it simply has to be entered accurately and formatted so that each item sits cleanly in its own row with clear column headings. You’ll be working entirely in Excel, so feel free to lean on built-in tools such as data validation, quick fill, and filters to keep everything consistent. Because the source material is pure text, no complex formulas are required—just precise, rapid entry and a quick check for typos or duplicated lines before you hand the file back to me. Deliverable: a single, fully populated .xlsx file that is error-free and neatly organised. If you can turn this around soon and keep accuracy at 100 %, let’s get started.

I have an Excel workbook filled with mixed data—text fields blended with numerical values—that now needs to be re-organized for easier analysis. Your job is to open the source spreadsheet, verify the integrity of every record, and then sort the information into clearly named sheets, one per category I will provide up front. Please keep every column header intact, carry over all cell formats that matter (dates, currency, percentages), and double-check totals so the numbers remain accurate during the move. Duplicates should be flagged, empty rows removed, and any formulas converted to values unless the calculation is still required inside its new sheet. Deliverable: one clean .xlsx file containing the newly structured workbook, with each category living on its own tab and a...

I have a single SQL Server table and I need a reusable SSIS package that will export it into five separate .xlsx workbooks. Each workbook must hold a different slice of the data, split strictly by rows—­not by columns or filters that change the structure. Here is what I already know: • Source: one T-SQL table in SQL Server 2019 • Output: five Excel Workbook (.xlsx) files, created in one run • Logic: the rows decide which file they belong to (for example, row-range, ID groups, or any other row-based rule we agree on) What I expect from you: • A ready-to-deploy .dtsx package built in SQL Server Data Tools / Visual Studio that performs the split and export in a single task flow • Connection managers configured for both SQL Server and Excel, u...

I need a clean, scalable template I can keep updating as my product range expands. Every entry must capture three details—Product name, Price, and Description—and the full list should stay automatically sorted alphabetically by name so nothing slips out of order when new items are added. Please set it up in a familiar, easy-to-edit format such as Google Sheets or Excel (whichever you feel is most efficient), include any simple formulas or filters necessary for instant A-to-Z ordering, and add clear instructions so I can duplicate rows or insert new ones without breaking the layout. Deliverables • An editable spreadsheet file (or shareable Google Sheet) with pre-defined columns for Product name, Price, and Description • Built-in alphabetical sorting that updates a...

I need a Word macro to streamline my document editing. The macro should: Format text: - Change font to Garamond, 10 pt. - Merge columns in a table. - Add parentheses around specific text. Automate repetitive tasks. Ideal skills and experience: - Proficiency in Word macros. - Experience with VBA (Visual Basic for Applications). - Strong understanding of text formatting and table management in Word. Looking forward to your bids!

A grade monitoring system was implemented with updated assessments for a number of students.

The job centers on bringing several raw files together into one clean, accurate Excel workbook. I have a mix of short text strings—product names, SKU descriptions, location codes—plus the corresponding inventory counts that must line up row-for-row. Your role is to enter the text data exactly as supplied, key in the inventory numbers without transcription errors, and then reshape each sheet so everything is easy to read and ready for quick analysis. Here is what has to happen: • Data entry – copy all supplied text fields and the related inventory figures into the correct columns, respecting spelling, capitalisation and the numerical precision already provided. • Sheet styling – apply consistent fonts, column widths, clear headings and any simple border...

I need reliable help getting our purchase data into Excel quickly and accurately. My top priority is clean, well-structured entry of every transaction from our existing digital files, so owners can review totals at a glance. Here’s what I’m looking for: • Transfer each purchase record from the supplied digital documents into my Excel template. • Verify dates, supplier names, item descriptions, quantities, costs, and tax fields as you go. • Flag any missing or unclear information so I can resolve it immediately. • Keep the worksheet tidy—consistent formatting, no stray formulas, and totals that update correctly. You’ll be working with straightforward spreadsheets (no macros required), but speed and precision are essential. If you’r...

I have an older-version .xlsm workbook whose VBA macros no longer behave as expected in the current release of Microsoft 365. The odd behaviour appears only when I run one particular macro; everything else loads fine. The full macro code is available, so you can step through, debug and rewrite any deprecated functions or references that the newer Excel object model now handles differently. Your task is to make that macro run flawlessly in the latest Office version, leaving the rest of the workbook untouched. A fixed fee of ₹500 is set aside for this quick repair. Acceptance criteria • Updated workbook opens and the target macro completes without errors or unexpected results in Office 365. • You provide a brief change log outlining what was modified in the VBA editor. I can...

I will provide raw customer data in CSV format and need it transformed into a single, well-structured Excel workbook that makes day-to-day analysis effortless. The core goal is insightful data analysis, so the sheet must highlight trends—monthly, quarterly, and year-over-year—while staying clear and intuitive for anyone on the team to update. Key elements to build in: • Clean data-entry section with drop-downs and data validation to prevent errors. • Automatic calculations using robust formulas and, where helpful, PivotTables so totals, averages, and growth metrics appear instantly. • Flexible sorting and filtering throughout, powered by well-named tables. • Professional formatting (themes, conditional formatting for red-flag values, freeze panes, ea...

I need a reliable pair of eyes on a batch of Microsoft Word documents and several Excel workbooks. The Word files mainly require a consistency pass so everything reads smoothly and follows the same style; I’ll share the exact focus and house-style guide once we’re underway. The heavier lift is on the Excel side. I want the data properly organised and cleaned, redundant or inconsistent entries fixed, and formulas checked or rebuilt so totals, look-ups, and any linked sheets calculate correctly every time. When that’s solid, the workbooks should be reformatted into a clear, presentation-ready layout that makes key numbers pop without breaking the underlying logic. Deliverables • Updated Word documents returned in their original folder structure (DOCX) • Clea...

I export survey results from a 95 question survey from Alchemer. The data can be exported as CSV or Excel and then run everything through Power Query. I have already taken the data part-way—filters, basic transformations and some formulas are in place—but I want a sharper, faster workflow. In particular I need help refining the data-cleaning and transformation steps in Power Query and then shaping the output into a fully customisable dashboard that can update automatically when fresh Excel exports land in the folder. to remove a lot of the manual manipulation that I'm currently doing. I need to filter out free text response questions and then with the data remaining, each of the questions I'm reporting on use a 5 point scale and from there I have custom formulas to g...

I need a clean, fully-checked .xlsx file that lists every Euromillions draw from the very first one in 2004 right up to the most recent result. Each row should show: • Draw date • The five main numbers and two Lucky Stars (the complete winning combination) • Winning jackpot amount That will come to roughly 1,000+ draws, so accuracy and reliable sourcing are essential. Alongside the raw data, please set up a simple way for me to spot combinations that have never been drawn. A helper sheet with a formula, pivot, or light VBA routine is fine—whatever is fastest and keeps the workbook lightweight. The goal is that, at a glance, I can enter or paste any five-plus-two combination and instantly see whether it has appeared before. Deliverables 1. containing the full...

I need a reliable pair of eyes on a batch of Microsoft Word documents and several Excel workbooks. The Word files mainly require a consistency pass so everything reads smoothly and follows the same style; I’ll share the exact focus and house-style guide once we’re underway. The heavier lift is on the Excel side. I want the data properly organised and cleaned, redundant or inconsistent entries fixed, and formulas checked or rebuilt so totals, look-ups, and any linked sheets calculate correctly every time. When that’s solid, the workbooks should be reformatted into a clear, presentation-ready layout that makes key numbers pop without breaking the underlying logic. Deliverables • Updated Word documents returned in their original folder structure (DOCX) • Clea...

I would like an Excel macro (VBA) that works as a rule engine. The user will enter different values such as: * Blood pressure * eGFR * LDL * Diabetes (Yes/No) * Heart failure (Yes/No) * Albuminuria * Additional variables that may be added later The macro should evaluate a set of predefined rules and generate recommendations. Examples: * If blood pressure is above 140/90 → recommend treatment A. * If blood pressure is below 140/90 → display that blood pressure is normal. * If the patient has diabetes → recommend Metformin. * If the patient has diabetes and eGFR is below 45 → recommend reducing the Metformin dose. * If the patient has diabetes and eGFR is below 30 → Metformin should be contraindicated. The system must be able to handle situations where multiple...

I’m looking for reliable help to keep our Excel-based records clean, current, and genuinely useful. My main pain point is data entry and database organisation, all of which lives in a series of interconnected Excel spreadsheets. Here’s what I need from you: • Accurate data entry and regular updating of existing rows so every figure is up to date. • Creating well-structured spreadsheets when a brand-new data set arrives, with clear tables, named ranges, and simple navigation. • Analysing the data to spot trends or inconsistencies and turning those findings into concise summary reports or charts I can share with the team. You’ll be working remotely on a part-time basis, so good communication and dependable turnaround times are essential. Solid Mi...

I need accurate transcription of a batch of digital files that contain a mix of text and numbers. Every record must be transferred exactly—text fields without spelling changes, numeric fields without rounding errors—into a clean, well-organized spreadsheet or database of your choice (Excel, Google Sheets, or an SQL table all work for me). Source material is already digitised, so no OCR or scanning is required; the focus is careful reading, correct copying, and consistent formatting. Please preserve any units of measure, date formats, and column headings exactly as they appear. Deliverables • Completed spreadsheet/database with 100 % of the provided records entered • Basic validation run (duplicate check, simple totals) to confirm accuracy • Progress file ...

I need a reliable pair of eyes on a batch of Microsoft Word documents and several Excel workbooks. The Word files mainly require a consistency pass so everything reads smoothly and follows the same style; I’ll share the exact focus and house-style guide once we’re underway. The heavier lift is on the Excel side. I want the data properly organised and cleaned, redundant or inconsistent entries fixed, and formulas checked or rebuilt so totals, look-ups, and any linked sheets calculate correctly every time. When that’s solid, the workbooks should be reformatted into a clear, presentation-ready layout that makes key numbers pop without breaking the underlying logic. Deliverables • Updated Word documents returned in their original folder structure (DOCX) • Clea...

I need a reliable pair of eyes on a batch of Microsoft Word documents and several Excel workbooks. The Word files mainly require a consistency pass so everything reads smoothly and follows the same style; I’ll share the exact focus and house-style guide once we’re underway. The heavier lift is on the Excel side. I want the data properly organised and cleaned, redundant or inconsistent entries fixed, and formulas checked or rebuilt so totals, look-ups, and any linked sheets calculate correctly every time. When that’s solid, the workbooks should be reformatted into a clear, presentation-ready layout that makes key numbers pop without breaking the underlying logic. Deliverables • Updated Word documents returned in their original folder structure (DOCX) • Clea...

I need a reliable pair of eyes on a batch of Microsoft Word documents and several Excel workbooks. The Word files mainly require a consistency pass so everything reads smoothly and follows the same style; I’ll share the exact focus and house-style guide once we’re underway. The heavier lift is on the Excel side. I want the data properly organised and cleaned, redundant or inconsistent entries fixed, and formulas checked or rebuilt so totals, look-ups, and any linked sheets calculate correctly every time. When that’s solid, the workbooks should be reformatted into a clear, presentation-ready layout that makes key numbers pop without breaking the underlying logic. Deliverables • Updated Word documents returned in their original folder structure (DOCX) • Clea...

I have two parallel tasks that move the same story forward, and I want one capable freelancer to handle both. First, I’ll share an Excel workbook filled with raw figures. Your role is to turn those figures into clear, visually compelling insights—think dynamic charts, pivot-based summaries and a concise dashboard that lets any non-technical stakeholder grasp the trends at a glance. If Power Query or simple VBA snippets make the workflow smoother, feel free to use them; the finished file just needs to remain fully editable in Microsoft 365. At the same time, I have several short video clips that must be stitched into a single, polished piece. The footage needs trimming, colour and audio clean-up, tasteful transitions and on-screen titles that match the look of the Excel visu...

I have a single spreadsheet—originally supplied by a client—filled with mixed text and numerical data that is currently bulky and hard to read. I need it turned into a polished, presentation-ready workbook. Specifically, every range must be organized into clear tables with consistent borders and subtle shading so different sections stand out at a glance. I also need practical conditional-formatting rules applied (for example, automatic colour coding of key thresholds, duplicates, or blanks) so the most important figures pop without manual scanning. The file is in Excel right now, though I may also open it in Google Sheets, so whatever you build should work seamlessly in either environment. No database work or scripting is required—just thorough, thoughtful spreadsheet d...

Silakan Daftar atau Login tuntuk melihat rincian.

I have several spreadsheets of raw financial data that need to be cleaned up and structured so I can work with them more efficiently. The core of the job is straightforward: enter any missing figures, double-check the numbers already there, then sort and filter the transactions into neat, searchable tables. Here’s what I need from you: • Transfer or paste the source data into a single, well-formatted workbook. • Apply consistent date, currency, and number formats. • Use Excel’s sort and filter tools to group transactions by account, category, or month so I can spot trends quickly. • Flag obvious irregularities or duplicates for me to review. • Add simple formulas or a running balance column where it adds clarity. The sheets will be shared via ...

I need reliable support maintaining and improving my inventory records in Excel. The work is fully online and centres on three recurring tasks: • Data entry – updating stock counts, SKUs and supplier details as new information arrives. • Data analysis – spotting discrepancies, slow-moving items and reorder points so I can react quickly. • Creating financial reports – turning the raw inventory data into clear monthly summaries of stock value, cost of goods sold and projected spend. I already have a partially built workbook that tracks most items, but formulas, pivot tables and basic Power Query connections still need attention. Your first milestone will be to review this file, streamline the structure and propose any additional fields that will help au...

I need a compact Excel workbook that helps me spot and explain sales trends at a glance. The main goal is to analyse current and past performance rather than produce long-range forecasts. You will have two data sources to work with: detailed customer-demographic fields and our marketing-spend figures for the same periods. There is no historical sales file yet, so the model must extract insight from these two tables alone. I would like you to keep everything in native Excel, leaning on SUMIFS, LOOKUPs and well-designed PivotTables instead of more advanced statistics. Clear, reusable formulas are important because the sheet will be updated monthly by non-technical staff. Deliverables • One Excel file containing: – Cleaned and well-structured raw-data tabs for the demograph...

I'm seeking an Excel and Google Sheets expert to create automated Business Intelligence (BI) dashboard templates for financial reports. The dashboards should have interactive charts, automated data refresh, and a premium aesthetic design. Key Requirements: - Platform: Both Excel and Google Sheets - Data Type: Financial reports - Features: - Interactive charts - Automated data refresh - Custom formulas Ideal Skills & Experience: - Proven expertise in Excel and Google Sheets - Strong background in financial data visualization - Proficiency in creating interactive charts and setting up automated data refresh - Excellent design skills for a professional look Please include samples of previous work. Looking forward to your proposals!

I’m clearing a backlog of purely numeric records—think invoice totals, receipt figures, and bank-statement lines—that must be keyed quickly and accurately. You’ll receive scanned documents in batches along with a ready-made Excel template and simple guidelines for mapping each figure to its correct column. Once the master sheet is complete, the same numbers need to be pushed into Tally ERP 9 so my ledgers stay up to date. Your day-to-day will involve: • Capturing every number exactly as shown, maintaining the original decimal precision. • Using basic Excel checks (SUM, VLOOKUP, simple Pivot filters) to confirm column totals and spot obvious entry slips. • Exporting the verified dataset in a format I can import directly into Tally. • Flag...

I need an Excel expert to segregate all costing into groups and provide a visual representation. Requirements: - Segregate costs into groups: Materials, Labor, Overhead. - Create visual representation: Bar chart, Pie chart, or Line graph. - Highlight specific data points: Highest cost, Lowest cost, Trends over time. Ideal skills and experience: - Proficiency in Excel - Experience with data visualization - Attention to detail - Ability to interpret and present data clearly

I need a reliable pair of eyes on a batch of Microsoft Word documents and several Excel workbooks. The Word files mainly require a consistency pass so everything reads smoothly and follows the same style; I’ll share the exact focus and house-style guide once we’re underway. The heavier lift is on the Excel side. I want the data properly organised and cleaned, redundant or inconsistent entries fixed, and formulas checked or rebuilt so totals, look-ups, and any linked sheets calculate correctly every time. When that’s solid, the workbooks should be reformatted into a clear, presentation-ready layout that makes key numbers pop without breaking the underlying logic. Deliverables • Updated Word documents returned in their original folder structure (DOCX) • Clea...

I want every lead that lands in WATI to appear—instantly—in our shared Excel file on the network drive. The same sheet must stay completely in-sync with WATI from that moment on: new messages, replies, tags, status changes, updated contact details, even the full conversation history should flow in automatically without anyone exporting or copying data by hand. Here is the core flow I need built and deployed: • Detect each new contact or message event in WATI (we rely on WATI as our main CRM layer, though we also keep a separate CRM instance). • Push or update the matching row in the shared Excel workbook in real time so the team can open the file at any moment and see a live, chronological record of every interaction. • Keep two-way integrity: if a lead&rsq...

मेरे पास एक शॉर्ट फ़िल्म की रॉ फुटेज तैयार है, मुझे इसे आकर्षक और सिनेमाई अंदाज़ में एडिट करवाना है। मुख्य रूप से मैं निम्न फ़ीचर्स शामिल करना चाहता हूँ: • Background music   • Text overlays (टाइटल व क्रेडिट्स सहित) • Smooth transitions हर सीक्वेंस के बीच मैं अपेक्षा करता हूँ कि एडिटर कलर करेक्शन, बेसिक साउंड मिक्सिंग और अंतिम एक्सपोर्ट (Full HD MP4) तक पूरी प्रक्रिया सँभाले। मैं आपको: – सभी रॉ क्लिप्स – म्यूज़िक ट्रैक्स और लोगो फाइलें – एक बेसिक एडिट स्क्रिप्ट/शॉट लिस्ट प्रदान करूँगा। मुझे आपसे: – फाइनल कट (rendered) – एडिटिंग प्रोजेक्ट फ़ाइल (Premiere Pro या आपकी प्रयुक्त सॉफ़्टवेयर फ़ाइल) – छोटे बदलावों के लिए सीमित रिविज़न की आवश्यकता होगी। यदि आपका पोर्टफोलियो शॉर्ट फ़िल्मों या यूट्यूब स्टाइल कहानिय...

I have several spreadsheets of raw financial data that need to be cleaned up and structured so I can work with them more efficiently. The core of the job is straightforward: enter any missing figures, double-check the numbers already there, then sort and filter the transactions into neat, searchable tables. Here’s what I need from you: • Transfer or paste the source data into a single, well-formatted workbook. • Apply consistent date, currency, and number formats. • Use Excel’s sort and filter tools to group transactions by account, category, or month so I can spot trends quickly. • Flag obvious irregularities or duplicates for me to review. • Add simple formulas or a running balance column where it adds clarity. The sheets will be shared via ...

I have an Excel workbook where every supporting tab holds numerical figures laid out in clearly defined columns. The Master sheet is meant to roll those numbers up, but its current formulas are incomplete and sometimes miss new entries. Your task is to rebuild the Master sheet logic so that, whenever I type or paste fresh numbers in any of the subsidiary tabs, the corresponding totals appear instantly and accurately on the Master sheet. All calculations are straightforward sums—no averages or counts—yet they must remain dynamic enough to keep working if extra rows are added later or if a new sheet follows the same column structure. Using robust techniques such as structured Tables, 3-D or INDIRECT references, or any smarter approach you prefer is fine as long as the end resu...

My goal is to wrap Microsoft’s Power Platform around our Simpro environment so the routine work takes care of itself and the team focuses on customers. The first phase centres on Copilot Studio and Power Automate flows that tap directly into Simpro data. With those flows I want to: • generate up-to-the-minute financial reporting • automate customer relationship touch-points and follow-ups • keep project management data current across teams • create new user agents and records once, then have them appear everywhere they should Once the data is moving cleanly, I need a set of interactive Power BI dashboards built on that same source so management can slice performance by job, technician, margin and timeframe without exporting spreadsheets. Everything ...

Necesito un desarrollador de macros experto en VBA para PowerPoint. La macro debe generar explicaciones paso a paso desde una presentación de PowerPoint. Requisitos: - Estructura de explicación: Por diapositiva - Contenido: Texto descriptivo y texto matemático Habilidades y experiencia ideales: - Dominio de VBA y PowerPoint - Experiencia en la creación de macros automatizadas - Atención al detalle y capacidad para seguir instrucciones Adjunto 4 archivos de PowerPoint. Dos de ellos tienen el ENUNCIADO y los otros 2 el PASO A PASO que deseo obtener. Lo que envío es solo una muestra. El trabajo sería mucho más amplio. Uno de los requisitos ineludibles es que de una diapositiva a la siguiente "no se mueva" nada. Solo aparece ...

I need a Microsoft Word mail merge set up so I can produce personalised letters from an existing Excel spreadsheet. The data file is already cleaned and organised in tabular form; what I am missing is an efficient, repeatable merge process and a professional-looking letter template that automatically pulls the correct fields. Here is what I expect: • A Word template with all merge fields correctly mapped to the columns in my spreadsheet. • Clear, concise instructions (or a short screen-share walkthrough) so I can update the Excel file and re-run the merge on my own whenever new records are added. • Verification that the final merged letters display names, addresses and any additional variables exactly as intended, without formatting glitches. If you are comfortable t...

Hi, I am looking for someone who can build me a very nice executive level organizational chart, we are talking about something very nice and professional, easy to understand, I want to be able to have the persons name, and conctact in there "bubble", if you click on it will open a window in outlook so you can email that person. I also want it so it can possibly read from an excel document and autopopulates to the nice presentation document you create. Not sure what you call this, but I just want to be able to edit the excel document, and it automatically will update the main document that I show my employees. We are talking about an organizational chart with a downward flow of about 15 people. This needs to be very nice and professional so I can be able to present it. You are l...

Project Name: Build a Microsoft Teams Search Bot ## 1. Project Overview I want to create a simple chatbot for my company's Microsoft Teams. When a staff member types an IP address or a Computer Name (Hostname) into the chat, the bot should automatically look it up in an Excel spreadsheet and reply with the details of that asset (like who owns it or its location). To keep our company data safe, I will not give the developer access to my system, and I do not want to import pre-made files. Instead, the developer will guide me over a live video call (like Zoom or Teams) while I share my screen, showing me exactly where to click on my laptop to build the bot myself. ## 2. Tools We Will Use We will use standard Microsoft tools that are already built into our company account: * Microsoft T...

Hi, I am looking for someone who can build me a very nice executive level organizational chart, we are talking about something very nice and professional, easy to understand, I want to be able to have the persons name, and conctact in there "bubble", if you click on it will open a window in outlook so you can email that person. I also want it so it can possibly read from an excel document and autopopulates to the nice presentation document you create. Not sure what you call this, but I just want to be able to edit the excel document, and it automatically will update the main document that I show my employees. We are talking about an organizational chart with a downward flow of about 15 people. This needs to be very nice and professional so I can be able to present it. You are l...