Visual Basic Jobs

I have a set of photographic PDFs that contain clearly defined tables, and I need every row and column lifted out and placed into a clean, fully editable Excel workbook. The spreadsheet will go straight into data analysis, so absolute accuracy in the numbers, headers, and cell alignment is crucial—no stray characters, merged cells, or mis-read figures. You may use OCR software such as ABBYY FineReader, Adobe Acrobat, Tesseract, or any comparable tool, but please double-check the output manually to be sure it mirrors the source tables exactly. I am not looking for a simple copy-paste; I expect a polished .xlsx file where each original table becomes a separate sheet, ready for formulas, filters, and pivot tables the moment I open it. Deliverable: • One Excel file (.xlsx) contain...

I keep my customer ledger in an existing Excel workbook. Each time I receive the bank statement it arrives as an Excel file, laid out on a single sheet that lists every transaction. The customer’s name appears in the description column of each credit line, and that is the key I use to decide which account the money belongs to. What I need is a lightweight VBA / Power Query routine (whichever is cleaner for this size of task) that lets me paste or import the statement and have every matching credit automatically recorded against the right customer inside my workbook. No extra clicks—just import, confirm, and the ledger updates. Core expectations • Read the statement from one sheet and detect credit rows. • Match each credit to the correct customer account by ...

I need a clean, interactive dashboard that lets me track both Liquidity Ratios and Profitability Ratios at a glance. My source data will arrive as Excel spreadsheets, so the solution must connect directly to those files, refresh their contents without manual copy-pasting, and roll everything up into clear visuals and tables that non-finance colleagues can understand. Each month I will drop a fresh spreadsheet into the same folder structure, and I expect the dashboard to update automatically once the file is in place. A quick “Refresh” button or scheduled refresh routine is fine—whatever keeps maintenance light. Core deliverables • A well-designed dashboard (Power BI, Tableau, Looker Studio, or another mainstream BI tool) showing key liquidity and profitability KPIs...

I need assistance with VLOOKUP to match and fetch inventory numbers. Requirements: - Use of VLOOKUP to match and fetch inventory numbers. - Work with multiple sheets within one workbook. Ideal Skills: - Proficiency in Excel, especially with VLOOKUP. - Experience handling multiple sheets in a single workbook. - Attention to detail to ensure data accuracy.

I'm seeking an experienced VBA developer to create an Excel macro. The primary goal is to automate reporting tasks to save time and reduce manual effort. Key Requirements: - Develop a VBA macro to automate repetitive reporting tasks. - Ensure the macro is user-friendly and well-documented. - Provide support for any troubleshooting post-deployment. Ideal Skills and Experience: - Proficiency in Excel and VBA. - Strong experience in automating tasks, particularly in reporting. - Problem-solving skills and attention to detail. Please provide examples of past work and relevant experience in your application.

I need assistance with VLOOKUP to match and fetch inventory numbers. Requirements: - Use of VLOOKUP to match and fetch inventory numbers. - Work with multiple sheets within one workbook. Ideal Skills: - Proficiency in Excel, especially with VLOOKUP. - Experience handling multiple sheets in a single workbook. - Attention to detail to ensure data accuracy.

I need an up-to-date, exhaustive list of every cash-segment equity traded on the National Stock Exchange of India. The goal is to paste the symbols directly into two separate TradingView watchlists, so please provide the list split in half (Part 1 and Part 2) in the exact ticker format TradingView recognises, with no indices, futures, options or ETFs mixed in. Deliverables • Part 1 and Part 2 text files (or a single spreadsheet with two clearly labelled tabs) containing the complete NSE cash share universe, ready for copy-paste into TradingView. • A quick note describing the data source and the date you pulled it, so I can verify its freshness. Acceptance criteria • Every active cash-equity ticker on NSE appears once—no duplicates, no missing symbols. • File...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I need a detailed spreadsheet to track employee training. The spreadsheet should handle the following: - Training Completion Status - As detailed in the email I will send - Automatic date renewal and frequency Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in creating automated tracking systems - Attention to detail and accuracy am also interested in a quote please for our training matrix for employees. What we do with this is we add in the training, there is a rag rating and a frequency set at the top which I needs changing to that it goes red when its expired, orange within 3 months and green until that point regardless of the frequency set, leave the frequency as this is an important part, we also want an option of NFA and N/A for people wh...

I have a complete project that has to be rewritten by hand—absolutely no computer fonts. The text should appear in clean, medium-sized Print lettering on standard lined paper so every line looks balanced and easy to follow. Once finished, I’ll need a high-resolution scan or a clear PDF of the entire handwritten set; discussing the exact page count and timeline will follow after we connect. If you’ve produced handwritten notes, assignments, or academic projects before, send over a sample so I can confirm the styling meets my expectations of neatness and readability. Reliability and punctual delivery are essential, as I’m working to a firm schedule. Looking forward to collaborating with someone who takes pride in beautiful handwriting and can turn this around on ti...

I need to build an excel spreadsheet that will take patients. The data in this sheet will be add to throughout the day but the next day delete the patients that are complete. I don’t want to store a lot of data. I want to see what staff are working with what patient and what are they working on. Is it an ambulatory appointment, is it a visit in the hospital, is it keep track of who is having a procedure. And lastly is this patient at an office visit. As for the data I need to see a weekly view and then after 4 weeks it gets moved to monthly then to yearly. The other part is some of these patients belong to a special program called EXH. I need to track my status and what percentage do they make up. There is other information on this daily summary sheet but does not need to b...

I have a batch of customer information locked away in several PDF files that needs to be brought into a clean, well-structured Excel workbook. Your job is to extract every required field, place it in the correct columns, format it consistently, and double-check the results so that the sheet is error-free. Source material • Native and scanned PDFs containing names, addresses, contact details, account numbers and a few date fields. • Some documents include multiple records per page, others just one. What I need from you 1. Convert the PDFs to Excel, making sure each customer record sits on its own row. 2. Standardise text (capitalisation, date formats, phone number structure, no trailing spaces). 3. Run quick validations—spot duplicate records, flag missing mandat...

You’ll be turning a series of large Excel files into polished, interactive Power BI dashboards for our Hyderabad office. The work goes beyond simple data import: I need clear charts and graphs for trend spotting, detailed tables and matrices for drill-downs, and the occasional custom visual when the built-ins just don’t tell the story. Because every source is Excel, your model-building, data-shaping, and DAX skills must be tight enough to keep refresh times low and errors at zero. I’ll share the cleaned spreadsheets, outline the KPIs, and expect a PBIX file plus a quick hand-off call that walks me through filters, bookmarks, and any custom visuals you’ve added. If you’re Hyderabad-based, on-site discussion is possible; otherwise, remote delivery is fine as ...

I need an experienced VB developer to add a robust report-generation module to my existing application. The core requirement is the ability to build reports whose layout can change at runtime—groupings, columns, charts, and even page orientation must adapt to user selections rather than following a fixed template. You will work with the current VB codebase, hook into my SQL Server data layer, then expose a clean way for end-users to design, save, and export their own reports (PDF and Excel are the primary targets). Crystal Reports or ActiveReports experience is a plus, though I am open to whatever reporting engine you feel gives the greatest flexibility in Visual Basic. Acceptance criteria • Users can choose any data fields and instantly preview the resulting report. &...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I need an Excel sheet converted into both MS Forms and HTML Form. The completed form should be downloadable in MS Excel format and integrate with Power BI. Requirements: - Form Types: MS Forms and HTML Form - Fields: Text inputs, Dropdown menus, Checkboxes, Automated scoring - Functionalities: - Data validation - Conditional logic - File uploads - Automated score calculator Ideal Skills: - Proficiency in MS Forms, HTML Forms, and Power BI - Strong experience with Excel, data validation, and conditional logic - Ability to implement automated scoring systems

I have an Excel file that’s meant to build a self-populating work roster, but the dashboard sheet is no longer talking to the roster grid. The Generate Roster button sits there looking pretty, yet nothing happens. What it should be doing is cycling through my predefined staffing rules—roles, shift lengths, maximum hours—and auto-filling the grid instantly. The core of the job is to trace where the VBA (or assigned macros) break down, restore the link between the dashboard inputs and the roster sheet, and make sure the Generate Roster button actually produces a complete schedule every time. Once fixed, I need clean, well-commented code so I can tweak the rules later without breaking everything again. Deliverables: • Working Generate Roster button that auto-fil...

I’m ready to commission a unique tattoo sketch that pulls together several meaningful elements for me. The artwork must weave Animals, Skulls, and Flowers into a cohesive composition, all executed in a black-and-grey palette. While I’m flexible on the artistic style itself, the final piece should be balanced, clearly readable at skin scale, and detailed enough for a professional tattooist to transfer without guesswork. Deliverables • High-resolution digital sketch (300 dpi or higher) in PNG or JPG • The original layered file (PSD, Procreate, or AI) so my tattoo artist can adjust sizing if needed • One round of minor revisions once I review the first draft Please share a brief note on how you’d approach marrying these three motifs, plus a glim...

I have several Excel spreadsheets that need to be brought up-to-date and reorganised so the information is clear, searchable and ready for analysis. The work is straightforward—but precision is essential. You will take raw data I provide, enter it accurately into the correct columns, apply consistent formatting, and keep everything neatly structured. Because the sheets feed into other reports I run, even a small error can cascade, so I value careful double-checking before each file is returned. If you spot obvious inconsistencies, feel free to flag them; I’ll confirm whether to correct or keep as-is. Turnaround matters, so once we agree on a hand-off schedule I expect the files back on or before the deadline each time. Experience with Microsoft Excel’s basic functio...

I need mixed text-and-numeric information transferred into a clean, well-structured Microsoft Excel file. Because no template exists yet, the first step is to design a workbook layout that groups the data logically, uses appropriate data types, and includes basic validation to minimize entry errors. The structure should include features like dropdown menus, data validation rules, basic formulas where appropriate, and clear formatting for ease of use. Once the format is approved by me through a submitted sample layout or brief guidelines, enter all supplied records, double-checking for typos, misplaced decimals, and inconsistent labels to achieve utmost accuracy. Key deliverables: • Custom Excel template with clear headings, data-validation rules, dropdown lists, and basic formulas a...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I need a detailed spreadsheet to track employee training. The spreadsheet should handle the following: - Training Completion Status - As detailed in the email I will send - Automatic date renewal and frequency Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in creating automated tracking systems - Attention to detail and accuracy am also interested in a quote please for our training matrix for employees. What we do with this is we add in the training, there is a rag rating and a frequency set at the top which I needs changing to that it goes red when its expired, orange within 3 months and green until that point regardless of the frequency set, leave the frequency as this is an important part, we also want an option of NFA and N/A for people wh...

I run compliance for a busy haulage company and need a single Excel workbook that keeps me ahead of every statutory obligation. The sheet must revolve around our WEEKLY TARGETS: when each licence, CPC refresher, driver medical or maintenance inspection is due, what percentage of the fleet is still outstanding, and whether we are on-track for the week. Here’s what I picture: the moment any target slips inside its warning window the cell turns amber; miss the deadline and it flips to red. At the same time an automatic email should leave Outlook so the relevant manager is warned without me lifting a finger. Formulas must update themselves from simple data entry (dates, counts, kilometres, etc.), calculate the remaining days and the KPI percentages, and feed a quick-view dashboard so I ...

A set of blank online application forms need to be completed quickly and with perfect accuracy. I will supply all of the source information in an easy-to-read spreadsheet along with clear field-by-field instructions. Your responsibility is simply to copy the data and submit each form, double-checking every entry before you hit “send.” Accuracy matters more than speed, yet I still need a prompt turnaround, so plan to keep me updated on progress at agreed checkpoints. Screenshots or a brief completion log for each batch will be enough to confirm submission. Deliverables • All application forms submitted online and confirmed as accepted • A completion log (spreadsheet or PDF) showing date and time of each submission and any notes on issues encountered Experience...

I need a custom options screener that will quickly surface the best trade opportunities across both call and put contracts. The primary goal is simple: filter live market data so I can spot setups worth acting on, without wading through every strike and expiration by hand. Here is what I have in mind: • Pull current option chains for my chosen tickers (US equities to start). • Apply configurable filters—strike proximity, days-to-expiration, volume/open-interest thresholds, implied volatility, or any other smart metric you suggest—to highlight trades with an attractive risk-reward profile. • Present the shortlisted trades in an intuitive table or dashboard, sortable by key statistics and linked back to the underlying chart. I am flexible on the tech stack; P...

I need a detailed spreadsheet to track employee training. The spreadsheet should handle the following: - Training Completion Status - As detailed in the email I will send - Automatic date renewal and frequency Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in creating automated tracking systems - Attention to detail and accuracy am also interested in a quote please for our training matrix for employees. What we do with this is we add in the training, there is a rag rating and a frequency set at the top which I needs changing to that it goes red when its expired, orange within 3 months and green until that point regardless of the frequency set, leave the frequency as this is an important part, we also want an option of NFA and N/A for people wh...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I’m a contractor who receives every work order as a text-based PDF. From each of these orders I have to issue three things on my own branded paperwork: a GST invoice, a completion certificate and a matching Excel summary sheet. I already have polished Word and Excel templates for all of them, so the visual layout is locked in. What I need is a small Windows-friendly .exe that lets me drop in a work-order PDF, automatically pulls out the key text (job number, client name, dates, amounts, GST, etc.) and shows the captured fields on screen. I’ll review or tweak anything that couldn’t be read and then hit “Generate”. The program should merge the confirmed data straight into my templates and instantly give me: • a finished DOCX invoice • a completed D...

My existing VB.NET project is behaving unpredictably: it sometimes crashes on startup and, even after it loads, other crashes appear at random. I need these bugs isolated and fixed so the application runs reliably every time it is launched and during normal use. You will receive the full Visual Studio solution and a short video showing the crashes in action. I have not added any custom logging yet, so incorporating meaningful exception handling or a lightweight logging mechanism is welcome if it helps trace the faults quickly. Deliverables • Corrected source code with clear comments on the changes • A brief summary explaining what caused each crash and how you resolved it • Simple reproducibility steps that confirm the issues no longer occur Please use standard VB...

hello, I need to create a solution in Excel that I would use to print school certificates... on the first Excel sheet I would enter general information about the school, teacher's name, number of students and class and by pressing the "generate" button it would open a new Excel sheet in which I would create a table overview of all subjects and calculate average grades... the data entered on the second sheet should be used on the third sheet to print the certificate. I would like to submit an outdated proposal of how it would look and how we used to use the certificate form on which the data should be printed More details: What kind of overview do you need on the second sheet? Grades and attendance What format do you prefer for the certificate on the third sheet? Custom te...

I have a series of projects that span Word, Excel, and PowerPoint, all requiring an advanced touch. In Word, I need complex documents cleaned up and formatted so headings update automatically, cross-references never break, and tables of contents look publication-ready. Expect to work with long manuscripts that already contain tracked changes and a variety of embedded objects. For Excel, the focus is data analysis and reporting. Raw CSV files must be transformed into dynamic dashboards: pivot tables connected to slicers, clear charts driven by named ranges, and formulas or Power Query steps that remain transparent for future updates. Attention to data integrity and reproducibility is essential; VBA or Office Scripts are welcome where they add real value. Finally, I want visually engaging...

I have several Excel sheets that hold both text and numbers and I need every record transferred, by hand, into a master template I will provide. Accuracy is critical—no copy-paste macros or automated scraping—just careful manual input so the final file mirrors the source exactly, including formatting such as date and currency styles. You’ll receive: • A folder of the original Excel workbooks • My blank master template and a short set of field-by-field notes Your task is simply to work through each sheet, key in the corresponding values, and double-check totals or formulas so nothing is lost in translation. When you return the completed template I will run a spot check; if everything aligns, the job is done. Familiarity with Excel’s basic func...

I have several Excel sheets that hold both text and numbers and I need every record transferred, by hand, into a master template I will provide. Accuracy is critical—no copy-paste macros or automated scraping—just careful manual input so the final file mirrors the source exactly, including formatting such as date and currency styles. You’ll receive: • A folder of the original Excel workbooks • My blank master template and a short set of field-by-field notes Your task is simply to work through each sheet, key in the corresponding values, and double-check totals or formulas so nothing is lost in translation. When you return the completed template I will run a spot check; if everything aligns, the job is done. Familiarity with Excel’s basic func...

I have a raw sales dataset that needs to go from messy spreadsheets to an insight-rich, client-ready dashboard. First, I want the data cleaned and structured in Excel—think advanced formulas, Pivot Tables, and error checks—so every field feeds smoothly into Power BI. Once the foundations are solid, the core of the job is building an interactive dashboard in Power BI. It must spotlight the metrics that matter most to me: sales by region, sales by product category, monthly sales trends, profit margins, year-over-year growth, and customer acquisition cost. I picture a mix of bar charts, pie charts, and line graphs, complemented by KPI cards for quick reference and slicers that let users filter results on the fly. Good communication is important; I need to understand not just...

Saya membutuhkan bantuan untuk menyusun model anggaran dari kumpulan data keuangan perusahaan kami menggunakan Microsoft Excel. Fokus utamanya adalah: • Membersihkan dan merapikan data transaksi yang sudah ada. • Mengelompokkan pos pemasukan dan pengeluaran secara logis. • Membangun template anggaran tahunan/bulanan berikut ringkasan varians. • Menambahkan grafik sederhana guna memvisualisasikan proporsi biaya dan tren saldo. • Memberi penjelasan singkat di tiap sheet agar tim akuntansi kami mudah memutakhirkan angka di kemudian hari. Data mentah akan saya kirim dalam format .xlsx; semua pengolahan wajib tetap di Excel (tanpa VBA atau makro, cukup rumus dan pivot table bila diperlukan). Hasil akhir yang saya harapkan adalah file Excel siap pakai beserta c...

I have a series of projects that span Word, Excel, and PowerPoint, all requiring an advanced touch. In Word, I need complex documents cleaned up and formatted so headings update automatically, cross-references never break, and tables of contents look publication-ready. Expect to work with long manuscripts that already contain tracked changes and a variety of embedded objects. For Excel, the focus is data analysis and reporting. Raw CSV files must be transformed into dynamic dashboards: pivot tables connected to slicers, clear charts driven by named ranges, and formulas or Power Query steps that remain transparent for future updates. Attention to data integrity and reproducibility is essential; VBA or Office Scripts are welcome where they add real value. Finally, I want visually engaging...

The workbook I rely on daily contains an existing VBA macro that should handle several automation steps for me, yet its current logic is off and the tasks don’t complete in the right order—or sometimes not at all. I need a developer who can step through the code, identify exactly where the flow breaks down, and rewrite those sections so the automation runs reliably every time the file is opened or the button is clicked. Here’s what I expect once the job is done: • The macro executes its full task sequence without manual intervention or unexpected stops. • Any loops, conditional branches, and object references are cleaned up so they’re easy to maintain. • I receive the updated workbook plus a brief changelog (commented in-line or a separate note...

I need a single Excel workbook that lets me enter raw sales data and instantly turns it into professional-looking bills. The sheet must pull every essential detail into the final print-ready invoice: • Customer information: name, full contact details, address, and account number • An itemised list of products or services with quantities, rates, and line totals • Clearly shown payment terms, plus auto-calculated subtotals, tax, discounts, and grand total Date handling is important—each invoice should grab the sale date, stamp a configurable due date, and feed those dates into a running tally so I can track what’s outstanding. A summary page that aggregates totals by day, week, and month will help me reconcile figures quickly. Please build the logic with s...

hello, I need to create a solution in Excel that I would use to print school certificates... on the first Excel sheet I would enter general information about the school, teacher's name, number of students and class and by pressing the "generate" button it would open a new Excel sheet in which I would create a table overview of all subjects and calculate average grades... the data entered on the second sheet should be used on the third sheet to print the certificate. I would like to submit an outdated proposal of how it would look and how we used to use the certificate form on which the data should be printed More details: What kind of overview do you need on the second sheet? Grades and attendance What format do you prefer for the certificate on the third sheet? Custom te...

I have several high-volume financial datasets that need a careful eye before they can be trusted for decision-making. Your first task will be to tidy up the raw files—spot and resolve inconsistencies, fill the inevitable gaps, and confirm every figure lines up across worksheets. Once the data is clean, I’ll lean on you to turn it into clear, executive-ready reports. Think dynamic Excel dashboards, concise tables, and visual summaries that highlight key performance metrics without drowning the reader in numbers. While the whole workflow—from organising and validating through to analysis—matters to me, the reporting stage is where I need the most help right now. If you have a knack for transforming rows of figures into insights people can actually use, you’ll b...

I have several high-volume financial datasets that need a careful eye before they can be trusted for decision-making. Your first task will be to tidy up the raw files—spot and resolve inconsistencies, fill the inevitable gaps, and confirm every figure lines up across worksheets. Once the data is clean, I’ll lean on you to turn it into clear, executive-ready reports. Think dynamic Excel dashboards, concise tables, and visual summaries that highlight key performance metrics without drowning the reader in numbers. While the whole workflow—from organising and validating through to analysis—matters to me, the reporting stage is where I need the most help right now. If you have a knack for transforming rows of figures into insights people can actually use, you’ll b...

I’m a contractor who receives every work order as a text-based PDF. From each of these orders I have to issue three things on my own branded paperwork: a GST invoice, a completion certificate and a matching Excel summary sheet. I already have polished Word and Excel templates for all of them, so the visual layout is locked in. What I need is a small Windows-friendly .exe that lets me drop in a work-order PDF, automatically pulls out the key text (job number, client name, dates, amounts, GST, etc.) and shows the captured fields on screen. I’ll review or tweak anything that couldn’t be read and then hit “Generate”. The program should merge the confirmed data straight into my templates and instantly give me: • a finished DOCX invoice • a completed D...

Procuro um profissional com experiência avançada em Microsoft Excel (ou Excel com VBA/Power Query/Power Pivot) para desenvolver um sistema de gestão de stock personalizado. O objetivo é criar uma solução simples e eficiente que permita: Registo de entrada de mercadorias no stock. Cadastro de novos produtos com referência, descrição, quantidade e outras informações relevantes. Registo de vendas, com baixa automática do stock sempre que uma venda for efetuada. Controlo em tempo real das quantidades disponíveis. Alertas de stock baixo (opcional). Registo de encomendas/reservas de clientes. Histórico de clientes e respetivas encomendas. Campo para registar a data de chegada da encomenda. Campo par...

I’ll send you an updated Excel workbook that contains several sheets. Your job is simple but must be done precisely: • Ensure every sheet keeps the exact column order, data types, and overall look we used in week 21—no unexpected formatting changes. • If anything was added across sheets, merge all columns so the structure stays identical throughout the workbook. • Upload the finished file to the designated SharePoint folder, replacing the prior week’s version. • Confirm the dataset still refreshes in Power BI without errors (no deep modelling required, just a quick check). Because the source is spread over multiple sheets and the downstream report relies on consistent formatting, strong Excel skills—tables, Power Query, data validation&md...

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