Visual Basic Jobs

I need a clean, interactive dashboard in Power BI that turns my raw sales data into clear, actionable insights. The core dataset is our historical sales (product, region, channel, time-series), and I want the visuals to spotlight trends, seasonality, and any anomalies so my team can make decisions quickly. Besides the sales figures, I also have customer feedback captured from Instagram. If you can weave that social-media sentiment into the same report—perhaps as a supplementary page or a slicer-driven overlay—that would be ideal, but the primary focus remains the sales story. You will receive: • CSV exports of the sales tables (fact and dimension files) • A JSON feed of the Instagram comments already tagged for sentiment Deliverables I expect: • A Power BI...

I need a detail-oriented professional to transpose mixed numeric and text records from several online databases into my Excel templates. You will receive step-by-step formatting guidelines that cover column order, cell styles, formulas and data-validation rules; these must be followed exactly so the sheets flow straight into our reporting dashboards. Quality is critical. Every entry should be double-checked for transcription errors, missing fields and consistency with the original source. I will be monitoring progress against a firm deadline, so I’m counting on quick turn-rounds without sacrificing accuracy. Deliverables • A fully populated Excel workbook that meets all provided formatting rules • A brief note (or separate tab) flagging any source anomalies or data you ...

I need a Windows-based desktop application that lets my team issue invoices through a fully Arabic, right-to-left interface. The program must handle the entire flow—creating invoices, tracking incoming payments as they are received, and producing clear, printable reports that management can review at any time. Because several staff members will be using the software simultaneously, it has to support multi-user operation with an admin layer where I can add, edit, or deactivate user accounts and decide who gets access to each feature. Deliverables: • Compiled Windows installer and executable • Complete, well-commented source code • Quick-start guide showing how admins create users, set permissions, and back up data • User manual (Arabic) covering invoice cre...

I have a series of raw Excel spreadsheets that I use strictly for record keeping, but right now they are messy and hard to read. I need you to step in and turn them into a clean, well-structured workbook. You’ll receive the data already in .xlsx format, so your first task is to apply the usual housekeeping: remove duplicates, correct any obvious alignment or text issues, and make sure each column has an appropriate data type. From there, I want the sheets sorted and filtered logically so I can locate information quickly—basic formulas such as SUM, AVERAGE, COUNTIF, or simple look-ups are enough for my needs. Once the data is tidy, convert key ranges into properly named tables; this is important because I rely on structured references later. If you see a spot where a small, ...

I have an Excel workbook that contains several thousand rows of raw data. The core issue is inconsistent text formatting—capitalisation varies, extra spaces appear, and some entries include stray symbols that break downstream look-ups and reports. Your job is to correct those text fields so every cell follows the same, clearly documented pattern. What I will provide • The original .xlsx file • A short style guide that shows how each column should read (e.g., “Title Case with no trailing spaces”) What I expect back • The same workbook returned with all text fields cleaned and validated—no broken formulas, no hidden characters, no mismatched encodings • A brief change log or summary sheet explaining the main fixes you applied so I can a...

I have a set of CSV files that hold purely numerical fields, and I need every value placed into a clean Excel workbook with the formatting still recognised as numbers. No extra calculations or text parsing—just an accurate, reliable transfer. A reusable method is important. If a concise VBA macro, Power Query routine, or a short Python script using pandas / openpyxl can automate the process, include it along with concise guidance. The final file must open error-free in the latest desktop version of Excel and display each column as true numerical data, with headers preserved (or created from the first row where they are missing) and sensible column widths for quick review. Deliverables • Populated Excel workbook. • Transfer script or macro, fully commented. • A ...

I'm looking for a 10-minute Excel test to evaluate basic Excel proficiency for work. The test should consist solely of multiple-choice questions, focusing on basic formulas and functions. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Knowledge of basic formulas and functions - Experience in creating multiple-choice questions

I'm having trouble with my Excel 365. I cannot get it to fill-in a cell with a different color using the Fill Color tool. I read the help section but it still does not work. I am not getting any error messages; it appears to work but no color shows. I need someone who is skilled in Excel troubleshooting and can help me resolve this issue.

I have a batch of business letters that must look polished and consistent in Microsoft Word. Each letter needs clear, well-aligned tables or simple charts embedded in the body, and a fully working mail-merge setup that pulls recipient data from an Excel sheet. Here is what I expect at the end: • A reusable Word template styled for formal letters (English and Hindi text will appear, so keep fonts and spacing bilingual-friendly). • Tables or charts formatted to match the template’s style, without breaking alignment when the data changes. • Mail-merge fields correctly mapped to my Excel list so I can generate all letters with one click. • Clean, error-free files returned in both .docx and PDF, ready to print or email. You are free to streamline the workfl...

I have a raw Excel workbook that needs a careful sweep before it can be used for reporting. The file holds a few thousand rows spread across several sheets and currently suffers from duplicate records, inconsistent date and number formats, scattered blank cells, and a patchwork of column names. Your job is to transform this messy source into a single, tidy .xlsx file that is ready for analysis. Standard Excel tools—filters, conditional formatting, VLOOKUP/XLOOKUP, PivotTables, data validation, and simple formulas—should be all you need; no macros or external add-ins are required. Deliverables • One consolidated, fully cleaned Excel workbook • A short “change log” sheet noting what you removed, merged, or reformatted • Optional: a brief note with...

I need an experienced analyst to turn my historical sales data into a forward-looking forecast entirely in Excel. Your task is to clean the raw figures, build an accurate predictive model, and present the results in a format that a non-technical stakeholder can understand at a glance. The dataset arrives as monthly CSV exports. After cleaning, I expect you to apply appropriate time-series or regression techniques available within Excel—think Data Analysis ToolPak, Power Query, Solver, or even VBA if it streamlines the workflow. Please document every transformation step so the model can be refreshed with new data later. Deliverables • A well-structured Excel workbook containing: – The cleaned data sheet – The predictive model with formulas fully visible &n...

I need a tidy, well-formatted Microsoft Excel workbook built with up to five separate sheets, each populated with text records that I will supply—every record includes a person or company name and a full mailing address. Your job is simple but must be flawless: transfer the information exactly as shown in the source documents, keep the spelling and line breaks intact, and place each field in its proper column so the file is instantly searchable and ready for mail-merge use. To keep things consistent, I will send you a template that shows the column headers I need (Name, Street, City, State/Province, ZIP/Postal Code, Country). Please stick to that layout, avoid merged cells, and apply the same basic formatting on every sheet. Deliverable: • One Excel (.xlsx) file containing 1...

I need my raw spreadsheet transformed into a clean, searchable workbook. The file contains a mix of text and numerical fields; your job is to enter the data accurately, format it consistently, then apply smart sorting and filtering so I can find what I need in just a few clicks. No macros or financial modelling are required—simply solid data entry skills and a good command of Excel’s built-in sort and filter tools. Once finished, I should receive a single .xlsx file with: • All records entered and double-checked • Uniform formatting across every column and row • Filters already in place on the key columns I’ll specify I’ll send the source material plus a brief field guide the moment we kick off. If you enjoy keeping data neat, this is a quick, ...

I have several digital files that need to be brought together in a single, well-organized Excel workbook. Your task is to enter the data accurately, structure it into clear tables, and then build insightful line charts that highlight the most important trends in the dataset. Here’s what I need from you: • A tidy Excel workbook containing all imported data arranged in logical tables. • A set of line charts—one for each key dataset—linked to those tables so that updates flow automatically. • Brief summary tables beneath each chart, showing the figures that drive the visuals. Accuracy is critical, and the final file should be easy for me to maintain and update without breaking any references. If you’re comfortable handling digital source files and ...

Je souhaite produire une série de vidéos qui expliquent, étape par étape, comment fabriquer des produits cosmétiques et les commercialiser sous sa propre marque. Le format retenu est un montage vidéo avec voix off claire en français. Le tournage devra avoir lieu sur site – dans un laboratoire ou une petite unité de production – afin de montrer chaque phase réelle de fabrication. Ce que j’attends : • Captation HD sur place (idéalement multi-cam) couvrant pesées, mélange, contrôle qualité et conditionnement. • Montage rythmé avec titres, incrustations d’ingrédients et schémas récapitulatifs, durée finale 5-8 min par produit. ...

Sales & Profitability Dashboard — Project Description Overview An interactive Excel-based dashboard that consolidates raw sales transaction data into real-time KPIs, breakdowns, and visualizations for tracking revenue, cost, and profitability performance across regions, product categories, time periods, and sales reps. Objective To give sales and finance stakeholders a single, self-updating view of business performance — eliminating manual pivot-table building and enabling faster, data-driven decisions on where revenue and margin are strongest or weakest. Key Features Live transaction table — a structured Excel Table capturing Date, Region, Category, Product, Sales Rep, Units Sold, Unit Price, and Unit Cost, with Revenue, COGS, Gross Profit, and Margin % calculate...

My information is still being keyed in manually, so I need a simple data-feed or template set that lets me enter the data once and have it flow automatically into the right places inside Word documents and Excel workbooks. If VBA macros, linked tables, form fields, or any other Microsoft-friendly solution will shave time off the process, I am open to it. The end result should let me: • type or paste the mixed data in a single, easy-to-use input sheet or form • have Word reports and Excel sheets populate instantly and accurately • keep everything editable later without breaking the links Please build, test, and hand over the finished Word and Excel files (with clear notes on how to add or adjust fields) so I can start using them straight away.

At present the staff is getting the scheduled auto emails with the Excel Zip file attachment as scheduled report from ERP. The Zip files are downloaded on the desktop. Then the unzipped Excel data (Trial Balance) is manually pasted in the financial file on Google drive. The further linkage is already there in Google file & the financials are getting ready. We require a script / programme which will 1) read all the scheduled auto emails from ERP of the dedicated email id 2) rename the zip file based on the remark written on the auto email body by storing the same in My drive of the dedicated email id 3) unzip the Excel files & store in My drive of the dedicated email id 4) we have prepared the control panel which has info of which file data is to be pasted in which sheet of which ...

I have several Excel workbooks containing a blend of text and numeric fields that now need to be moved into a clean, well-structured master sheet. Your job is straightforward but detail-critical: copy the information exactly as it appears, keep all numbers in their proper formats, and double-check that no text strings are truncated or misplaced. You will receive the source files via a shared folder. Please return one consolidated Excel file, already de-duplicated and sorted by the column order I will provide once we start. Accuracy is the top priority; I will run spot checks against the originals before signing off. If you work comfortably in Microsoft Excel, understand basic data validation, and can turn this around promptly, I look forward to collaborating with you.

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

Saya mencari seorang admin yang dapat saya percayai untuk menangani penjadwalan tugas harian menggunakan software manajemen tugas khusus (bukan Excel atau Google Sheets). Fokus Anda adalah memastikan setiap tugas tercatat rapi, memiliki tenggat jelas, dan ter-update tepat waktu. Ruang lingkup: • Membuat dan memelihara daftar tugas harian di aplikasi yang saya gunakan (detail akses akan saya berikan). • Menetapkan prioritas, tenggat, dan pengingat sesuai arahan saya setiap hari. • Memantau progres serta menandai tugas selesai atau memindahkannya bila ada perubahan prioritas. • Mengirim ringkasan status harian singkat melalui chat atau email di akhir hari kerja. Saya mengutamakan ketelitian, komunikasi cepat, dan sikap proaktif dalam menyarankan perbaikan alur ker...

I have several spreadsheets that need to be built out, cleaned up, and kept current in Microsoft Excel. The core of the job is straightforward data entry and basic spreadsheet management—copy-pasting data from source documents, organising it into the right columns, applying simple formulas where needed, and double-checking for accuracy before saving each file. You will work exclusively in Excel; no Google Sheets or other tools are required. If you have a solid eye for detail and can follow clear naming conventions, you’ll find this task smooth and repetitive—in a good way. Deliverables • Fully populated Excel workbooks provided back to me in the same file format • Zero placeholder cells or formatting errors • A short completion note outlining an...

I have several spreadsheets that need to be built out, cleaned up, and kept current in Microsoft Excel. The core of the job is straightforward data entry and basic spreadsheet management—copy-pasting data from source documents, organising it into the right columns, applying simple formulas where needed, and double-checking for accuracy before saving each file. You will work exclusively in Excel; no Google Sheets or other tools are required. If you have a solid eye for detail and can follow clear naming conventions, you’ll find this task smooth and repetitive—in a good way. Deliverables • Fully populated Excel workbooks provided back to me in the same file format • Zero placeholder cells or formatting errors • A short completion note outlining an...

I need an end-to-end Tableau dashboard that puts sales performance front and center. The data set is ready; what I’m missing is the polished, interactive layer that lets managers explore results on their own. Here is what matters most to me: • Key metrics: Total sales and Sales by product must be clearly surfaced, with room to add growth rate later if we decide it’s useful. • Visuals: Combine Bar, Line, and Pie charts so users can switch perspectives without leaving the workbook. • Interactivity: Filters by region, product category, and time period, plus hover tooltips and drill-downs that reveal underlying tables. • Storytelling: A concise KPI banner that highlights highs and lows at a glance before users dive deeper. Deliverables • A package...

I need an experienced Excel accountant who can jump in right away and structure a clean, accurate and complete assessment of the financial statements in the excel task. for my upcoming financial reporting. All figures are provided. I want the final workbook to: • flow automatically from clearly labeled input tabs to the finished solutions tab, • use formulas as much as possible (no hard-coded subtotals) so I can update figures later, and • include a brief checksum or cross-check of nevessary Formatting should match standard UK GAAP headings—Assets, Liabilities, Equity—so the file is presentation-ready for management. I’m on a tight deadline and need the completed, error-free workbook delivered ASAP, ideally within the next 24 hours. If you’re co...

i need a desktop tool which converts scanned pdfs to excel with atleast 99% accuracy. its urgent need.

I have a set of Excel workbooks that need a smarter layer of automation. Your job is to weave in solid, intermediate-level formulas—VLOOKUP, nested IF statements, and similar functions—to turn raw data into information I can slice and present quickly. Alongside the formulas, I need reliable data sorting and filtering controls as well as conditional formatting rules that instantly flag exceptions and trends. The focus is on clear, maintainable solutions; no VBA or complex array formulas are necessary. Deliverables: • Updated .xlsx file(s) with all new formulas, sorting/filtering views, and conditional formats in place • A concise in-sheet note or README explaining the logic so I can update it later I’ll share the current workbook as soon as we start and will...

I have several very large spreadsheets that need to be audited, cleaned, and uniformly formatted. The job revolves around identifying and fixing discrepancies quickly while keeping every entry accurate. You’ll be diving into thousands of rows, using VLOOKUP, XLOOKUP, and any other advanced functions you find useful to reconcile records, highlight mismatches, and verify totals. I care a lot about proper formatting—leading zeros must stay intact, text-to-number issues have to be resolved, and custom field structures need to remain consistent from sheet to sheet. Throughout the process I expect frequent spot-checks to confirm that formulas are returning the correct values and that no data has been lost or overwritten. Deliverables: • One consolidated, fully audited work...

I have a single Excel/CSV master file that captures every employee movement in the organisation, and I need a dynamic Power BI dashboard built around it. The goal is simple: the moment I replace or append the source file, every visual should refresh without any extra work from me. What the report must show: • Total headcount • Employee attrition rate • New-hire and exit counts I want users to slice these numbers region-wise, department-wise, and role-wise through interactive filters. Clear trend lines, month-over-month comparisons, and a clean summary card layout are preferred so executives can grasp churn patterns at a glance. Deliverables 1. A PBIX file containing a tidy data model, DAX measures for the metrics above, and well-labelled visuals. 2. Automated refresh se...

I need an experienced Siemens SIMATIC PCS 7 / WinCC engineer to build a read-only connector from an existing PCS 7 DCS system to an existing Excel MIS workbook. The plant already uses PCS 7/WinCC and the Excel workbook already contains formulas and a management dashboard. The goal is to automatically extract selected DCS values and populate only the approved Excel input cells without modifying plant-control logic. The freelancer should first review the actual PCS 7 setup and recommend the safest supported method, such as Siemens-generated Excel/CSV export, OPC UA/OPC DA, OpenPCS 7, Process Historian, WinCC archives, or another approved read-only interface. Scope includes: identify the correct PCS 7/WinCC data-access method; map approximately 50–100 required tags/parameters to Exc...

I have a collection of Microsoft Word documents and I need every standalone paragraph lifted out and placed into an Excel workbook, with each paragraph occupying its own row. No tables, images, or contact blocks—just the plain text paragraphs exactly as they appear in the source files. You may use any reliable method you prefer (manual copy-paste, VBA, Power Query, or a small Python script with python-docx and openpyxl) so long as the final result is clean and accurately mirrors the original wording, punctuation, and line breaks. Deliverables • One .xlsx file per Word batch, each row containing a single paragraph in sequence • Source-to-row mapping retained (either by file name in a separate column or a clear index) • Completed file returned error-free and read...

I have a collection of PDF files that contain structured tables I need moved into a clean, well-formatted Excel workbook so I can run data analysis right away. Your task is a straight conversion—no deduping, reformatting of dates, or other transformations—just an accurate, cell-by-cell transfer. Key points to keep in mind • Every table, every row: nothing can be skipped. • Three columns are critical and must be clearly preserved in the sheet: Dates, Values, and Text descriptions. Feel free to flag them with a subtle background colour or bold header so they stand out the moment I open the file. • Sheet layout should mirror the PDFs, making it easy for pivoting and charting later. Deliverable An .xlsx file (or multiple sheets if that keeps things tidy) ...

I’d like my current Excel rota transformed into a clean, automated workbook that practically manages itself. Right now dates are out of order and shifts run together; I need everything sorted chronologically with each shift clearly separated so I can scan the week in seconds. The file must keep one critical data point—employee names—at its core, because every formula will rely on that. As soon as I enter a start and end time I want the sheet to calculate the shift length and each employee’s running monthly total automatically. If two people accidentally overlap or a shift doubles up, conditional formatting should light it up straight away. Presentation matters too. Please apply a single, professional font across the workbook; beyond that I’m not fussy about ...

I’m working with an Excel rota that has become unwieldy and hard to trust. I need you to reorganise it so every working day appears in chronological order, start- and finish-time columns calculate shift length automatically, and monthly hour totals are ready at a glance. Please separate the data by shifts (not by clients or locations) so each type of shift is simple to scan and edit. Because I frequently adjust start or finish times, all totals must update instantly through robust formulas, not manual entry. A key requirement is highlighting any scheduling conflicts; the moment two shifts clash I want clear conditional-formatting alerts so I can spot and fix issues right away. While you’re streamlining the layout, keep the original information intact—just tidy th...

I need all the text and numerical information that currently lives in several Excel and Word files transferred into one clean, consolidated Excel workbook. The end file should: • Keep the original values exactly as written—no rounding, spelling tweaks, or re-formatting that changes meaning. • Place each record in its own row, with clear column headers I can filter or pivot. • Use consistent data types (numbers stored as numbers, dates as dates, and so on). I will supply the source files, along with a short field-mapping guide so you know which column each piece of data belongs in. Please double-check totals and spellings, flag any ambiguous entries, and leave a comment where something seems off. Accuracy and neat formatting are more important to me than speed, ...

I need experienced help verifying a volume of customer data that has already been keyed into our system. The task is strictly data entry–focused, but rather than entering new records you’ll be confirming the accuracy and completeness of existing ones. You’ll cross-check each field against the original source documents we provide, flag discrepancies, correct obvious errors, and leave clear notes wherever something can’t be resolved. Everything lives in a shared Google Sheet that connects to our CRM, so solid spreadsheet skills and care with formulas, filters, and simple look-ups will speed your work. Confidentiality is crucial because the file contains names, contact details, and purchase histories. Deliverables • A fully verified sheet with corrected or ann...

Hello, I have a list of details, using those you need to collect a lot of data from a specific website. I will show you how to scrape the details like Name, Email, and Phone numbers, you just need to follow the pattern..

Not so much of a project, but a relatively simple task for an experienced Microsoft Word geek. I have two Microsoft files. v1 was created and saved after 5mins in April this year. Unfortunately, it does not contain some final drafting that was lost when I clicked the wrong button at the time. v2 of the document is a simple cut-n-paste of the original with corrected 2nd bullet (highlighted) My Ask/Request Update to the original v1 document with the 2nd bullet replaced with (v2 Bullet 2) without changing the original Properties. OR the v2 document (as is, no change to document content) but showing the original document properties (last modified & created) see attached Word file called Document Properties. The final Word document - whichever approach (above) is taken needs to have h...