Visual Basic za aplikacije Jobs

Make a professional banking app in Microsoft access format. Currency preferably in (K) Zambian kwacha It should be able to collect customer, account, and transaction details e.g. bank statements, loan details.

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