Visual Basic for Apps Jobs

Hi, I’m looking for a simple Excel attendance and daily task tracker that works completely offline using Excel VBA/macros. This is meant to be a small and simple project, not a complicated HR system. You can use a premade Excel template and customize it if that’s easier. I attached screenshots/mockups showing the idea and layout I’m looking for. Budget: Around $10–15 only, so please don’t bid high for this project. Main Requirements: 1. Check In Button When the user clicks “Check In”: * Automatically record current date and current time from the computer system. * Employee details should NOT come from the Windows/computer username. Employee details should instead come automatically from a protected Admin sheet: * Employee ID * Employee...

I need a single Excel workbook that lets me broadcast personalised WhatsApp Business messages straight from the sheet. Core flow is simple: • I drop or paste a contact list into a dedicated sheet (structure: phone number, name, any merge fields you feel are useful). • I type one master message that can pull those merge fields so every recipient gets a tailored text. For this first release we will stick to text-only messages; later on I may ask you to extend it to images or documents, so please keep the code modular. • When I hit “Send”, your VBA (or Office Script) routine should call the official WhatsApp Business API, handle authentication, queue the messages and confirm each send. Stability is key. The workbook must trap API errors, surface clear status m...

I have one master text column in an Excel workbook that feeds about twenty-five different language versions spread through the same file. Right now, every language cell is filled by hand, so whenever I adjust the English source text I have to hunt through each translated column and update it manually. What I need is a clean way for any text change I make in that master column to cascade automatically to all of the other language columns. Whether you solve it with formulas, named ranges, Power Query, or a quick VBA macro is up to you—the only requirement is that the result works reliably in the current workbook structure and is easy for me to maintain. Please deliver: • The updated workbook with the automation in place • A brief note (or short Loom video if you prefe...

I need a dual-format inventory tracker that works the same way in Google Sheets and in Microsoft Excel for my line of physical products. The file should let me see stock on hand at a glance, record every movement in and out, and warn me when any item drops below its reorder point. It also needs to remain fully editable so I can grow the catalogue without breaking the formulas. Core requirements • One master list that holds SKU, product name, cost, selling price and current quantity. • Automatic balance update whenever I add a purchase, a sale or an adjustment. • A clean dashboard sheet that totals inventory value and highlights low-stock items. • Seamless switching between Google Sheets and Excel; if you use Apps Script or VBA, include a no-code fallback so the...

I want to turn my existing invoice layout into a smart MS Word template that can read data straight from an Excel file and, with a single action, output a locked, ready-to-send PDF. Here is what I need: • Source data will always come from a designated Excel workbook—client name, multiple line items, unit prices, totals. Your solution should cope with a variable number of rows without breaking the layout. • I will give you the exact invoice design in Word; simply keep that look and feel. No extra styling or embellishment is required once it arrives in PDF form. • After the merge, the file must save itself as a read-only PDF in the same folder (or a path I can later adjust) using the invoice number in the filename. Deliverables 1. The automated Word template with merge...

I want an Excel workbook that connects to the (public access) and continuously pulls the Nifty 50 option-chain data I specify: the at-the-money strike, plus five strikes out-of-the-money and five strikes in-the-money. For each of those eleven strikes the sheet must capture three fields—Open Interest, Change in Open Interest, and Volume Strike Price—and refresh them automatically every three minutes. Inside the file I need a time-stamped line graph that updates in real time, plotting the same three metrics so I can watch how they evolve through the session without touching the sheet. A single click to start or stop the refresh loop is fine; otherwise the process should run silently in the background. Please build with whichever approach inside Excel you prefer—VBA, Powe...

I keep a master Excel sheet in English and rely on Excel’s built-in Translator to create 25 separate language files. My workflow breaks down whenever I edit the English version—especially when I apply new formats or reorganise the entire sheet—because the changes do not cascade to the translated copies. What I need is a single, central database-style workbook that will: • detect any update I make to the English sheet (I often revise the whole sheet, not just a few cells) • run Excel Translator in the background to refresh all 25 language sheets instantly • paste the translated output as pure values so my software reads clean cell contents, never formulas • replicate every formatting tweak exactly across all languages, preserving fonts, colou...

I have a growing number of spreadsheets that need to be cleaned and formatted the moment new data is dropped in. Manually removing duplicates, hunting down obvious errors, then sorting and filtering every column is slowing the whole workflow. I want a single, reliable macro—written in VBA—that can run through each sheet, spot and delete duplicates, flag or purge simple entry mistakes, and finish by applying the correct sort and filter rules I’ll specify.

I need a single Excel file that can turn my raw inputs into polished, client-ready price quotations in a click or two. The core job is straightforward: automate the quote-building process so I’m never re-typing numbers again. Here’s how I picture it working: • I enter or paste a product/service list, the customer’s basic details, plus the required quantity and any discounts. • Your VBA or Power Query logic pulls those inputs into a quotation sheet, calculates totals and taxes, then applies my branding—logo, colour palette, even preferred fonts—before laying everything out in a clean template. • I want to be able to switch among a handful of templates and rename or hide fields without touching the code. A simple control panel or clearly labe...

I want to turn my existing invoice layout into a smart MS Word template that can read data straight from an Excel file and, with a single action, output a locked, ready-to-send PDF. Here is what I need: • Source data will always come from a designated Excel workbook—client name, multiple line items, unit prices, totals. Your solution should cope with a variable number of rows without breaking the layout. • I will give you the exact invoice design in Word; simply keep that look and feel. No extra styling or embellishment is required once it arrives in PDF form. • After the merge, the file must save itself as a read-only PDF in the same folder (or a path I can later adjust) using the invoice number in the filename. Deliverables 1. The automated Word template with merge...

Good at ConnecTeam scheduling and planning, Mandarine and/or Cantonese preferred but not a must

Sto cercando uno sviluppatore VBA che trasformi un nostro file Excel in uno strumento completamente automatizzato. L’obiettivo principale è l’automatizzazione dei processi: partire da un foglio di calcolo Excel già esistente, ripulire i dati e rimuovere voci superflue con un solo clic. Attività chiave • Analizzare la struttura attuale del file. • Sviluppare macro VBA che individuino record inutili, normalizzino formati e consolidino i dati. • Integrare un pulsante o shortcut che avvii l’intera procedura. • Documentare il codice con commenti chiari e, se utile, un breve manuale d’uso. Criteri di accettazione • Pulizia completa: niente duplicati né campi vuoti non necessari. • Processo stabile e ri-...