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

Saya berencana memulai karier sebagai freelancer di bidang desain grafis dan membutuhkan pendampingan praktis dari orang yang sudah berpengalaman. Latar belakang saya kuat di Excel dan Word, tetapi belum terbiasa dengan tool desain standar industri seperti Adobe Photoshop, Adobe Illustrator, atau CorelDRAW. Apa yang saya perlukan: • Penjelasan langkah-demi-langkah untuk memetakan layanan desain grafis yang paling cocok bagi saya. • Sesi bimbingan online singkat (chat atau video) yang membantu saya mengenal dasar penggunaan Photoshop, Illustrator, maupun alternatif lain yang Anda rekomendasikan. • Contoh proyek latihan—misalnya logo, konten media sosial, atau brosur—beserta umpan balik agar saya punya portofolio awal. • Saran praktis tentang cara menen...

I need an expert in Microsoft Excel to assist with advanced formulas and calculations. The ideal candidate will have: - Proficiency in array formulas and nested functions - Experience with complex conditional calculations (e.g., IF statements) - Strong problem-solving skills to tackle intricate Excel challenges Please provide examples of previous work and relevant qualifications.

I laid out my worksheet in Excel as two equal-width columns on a landscape page, yet every time I hit Print, the content drifts left and the fold line no longer falls between the columns. I’d like the page layout, margins, and scaling to adjust automatically so the columns sit perfectly centered—each one occupying exactly half of the sheet—without my having to tweak settings every time. You’ll either walk me through the exact Page Layout settings (margins, print area, scaling, centering) or make the changes directly in a copy of the file once I share it. The goal is simple: open Print Preview, see two symmetrical halves, press Print, fold the sheet, and have the crease land cleanly between the columns. Acceptance criteria • Print Preview displays both colum...

I need to automate my export business processes currently managed in Microsoft Excel. I'm looking for a solution that can streamline and automate the following tasks: - Data Entry: Reduce manual input and errors. - Generating Reports: Create automated, real-time reports. - Tracking Shipments: Automate and simplify shipment tracking. Ideal skills and experience: - Expertise in Excel automation and integration. - Experience with export business processes. - Ability to develop custom solutions or workflows. Looking for someone who can deliver an efficient, user-friendly automation flow.

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

Excel Automation for Billing & Financial Projections We are looking for an experienced Excel automation freelancer to develop a smart and user-friendly Excel-based system for billing, financial projections, and reporting dashboards. Scope of Work: Create dynamic financial projection models Develop automated calculations and summaries. Design dashboards and MIS reports. Use advanced Excel formulas, Pivot Tables, Power Query, and VBA/macros wherever required. Ensure the file is easy to use and scalable for future requirements. Key Requirements: Strong expertise in Microsoft Excel automation Experience in financial modeling, billing systems, and projections Knowledge of VBA/macros preferred Ability to create clean, professional, and efficient templates Deliverables: Fully functional a...

I need a set of tightly linked Excel workbooks that take sales leads from first contact through close, flag every key project milestone along the way, and—with a single click—spin out clean performance reports for management. Scope of work • Build advanced automation with VBA macros. Think push-button forms that add or update records, automatic time-stamps, self-refreshing pivot tables, and dynamic charts that redraw as data changes. • Three core functions are mandatory: tracking sales leads, monitoring project milestones, and generating performance reports. All dashboards, summary views, and print-ready reports should update without manual intervention. • No direct tie-in to Salesforce, HubSpot, or Zoho CRM is needed right now, so the files must remain fu...

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

How to Use in Excel: Create New Workbook: Open a blank Excel workbook. Rename Sheets: Double-click on “Sheet1”, “Sheet2”, “Sheet3”, “Sheet4” at the bottom and rename them to “Instructions”, “Summary”, “Labor Detail”, and “Non-Labor & ODC Detail” respectively. Copy and Paste: For each sheet, copy the entire table (including column headers) from above and paste it starting in cell A1 of the corresponding Excel sheet. Adjust Formulas: Excel should automatically adjust the SUM ranges if you add/remove rows within the defined sections (e.g., adding a new role under “Project Management”). However, always double-check, especially if you add sections outside the initial rows. Fill in Yo...

I’m wrapping up my semester and must submit an Excel assignment built around sales data. The professor expects multiple linked worksheets that work together, with VLOOKUP as the key formula connecting them. I will share the exact prompts, column headings, and any sample numbers right after we start, but here’s the core of what I need: • A clean, realistic sales dataset split across two-or-more sheets—think Orders, Products, or Regions—so VLOOKUP can pull details from one sheet to another. • Correct, error-free VLOOKUP formulas that return the right values no matter how the underlying data changes. • Thoughtful formatting: clear headings, consistent number formats, and basic conditional formatting where it improves readability. • No macros ...

I have several Excel workbooks that need to be brought into shape from the comfort of your own workspace. The job is entirely data-entry focused, but it goes a step beyond simple typing. After you enter the raw figures, I need each sheet formatted neatly—consistent fonts, borders, cell styles, and quick conditional-formatting where it makes sense. Once everything looks clean, you will add basic formulas and functions so the totals, averages, and other simple calculations update automatically. Nothing extremely advanced is required; SUM, AVERAGE, simple IF statements, and similar built-in functions will cover almost everything. Deliverables: • Completed workbooks with every record accurately entered • Clear, professional formatting applied across all sheets • Fo...

I need an Excel expert to create a financial data sheet with automated calculations. Requirements include: - Input financial data like budget forecasting and expense tracking - Automated calculations for budget forecasting and expense tracking - Ability to pull specific values from Sheet 1 to Sheet 2 based on chosen cells Ideal Skills and Experience: - Advanced Excel proficiency - Experience with automated calculations and data manipulation - Attention to detail and accuracy Looking for someone who can deliver a professional and functional Excel sheet tailored to my needs.

My dataset mixes text fields—such as product descriptions and notes—with numerical figures like prices and quantities. I need an Excel file that brings all this information together in a clean, easy-to-use layout. Because no template exists yet, the first step is to design one that fits the data flow and is scalable for future records. Key task: apply cell merging and splitting so headers, sub-categories, and totals line up neatly. Once the structure is in place, paste a short sample of my mixed data into the sheet to show that everything aligns correctly. If you spot ways to improve readability—say, light conditional formatting or basic data-validation prompts—feel free to weave them in as long as they don’t slow down entry. Deliverables: • A reusabl...

My dataset mixes text fields—such as product descriptions and notes—with numerical figures like prices and quantities. I need an Excel file that brings all this information together in a clean, easy-to-use layout. Because no template exists yet, the first step is to design one that fits the data flow and is scalable for future records. Key task: apply cell merging and splitting so headers, sub-categories, and totals line up neatly. Once the structure is in place, paste a short sample of my mixed data into the sheet to show that everything aligns correctly. If you spot ways to improve readability—say, light conditional formatting or basic data-validation prompts—feel free to weave them in as long as they don’t slow down entry. Deliverables: • A reusabl...

I have roughly 100 pages of images and PDFs that contain tables and charts which need to be keyed accurately into a single Excel workbook within five days. Accuracy is paramount, but layout matters just as much. Here is exactly what I’m after: • Every table transferred verbatim, preserving numeric precision and text strings. • Specific column widths and alignments replicated so the sheet mirrors the original layout. • Conditional formatting applied to highlight key values exactly as shown in the source. • Custom headers and footers placed on each worksheet to match the originals. A clean, well-structured file is the end goal—no extra blank rows, no merged-cell surprises. If you prefer OCR to speed things up, that’s fine, but the final sheet...

Canva Sheet to Editable Excel I have an Excel file that was originally put together in Canva and then exported in a non-standard Excel format. It opens, but a lot of the cells are locked in place and I can’t comfortably add new rows, columns, or formulas. What I need is a clean, fully editable .xlsx version that keeps the existing layout yet behaves like a normal desktop Excel workbook. Every cell should be editable, all merged-cell issues removed, and I should be able to insert additional data anywhere without breaking the structure. Feel free to streamline the file behind the scenes—unhide or re-create any hidden sheets Canva may have added—so it functions smoothly in Microsoft Excel for Windows and Mac. Deliverable: one polished .xlsx file ready for day-to-day use,...

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 have a collection of Excel spreadsheets that need their contents moved into a new master workbook. It’s a straightforward copy-paste job, but I need the final file reorganized into clear, logical categories rather than mirroring the original layout. Each source sheet is consistent and well-formatted, so the task is mainly about accurate selection, pasting, and correct categorization. The finished workbook should make it easy for anyone to filter or sort by those categories without further cleanup. Deliverables • One consolidated Excel file with every entry placed under its appropriate category tab or column structure • Spot-check report confirming that totals and record counts match the originals Accuracy is the priority: no missing rows, no shifted columns, an...

Necesito que construyas una hoja de cálculo en Excel que sirva como lista de precios dinámica y cotizador automático. Mi prioridad es que los precios se actualicen de forma automática a partir de una tabla maestra, para que cada vez que cambie un valor el resto de los cálculos reflejen inmediatamente la nueva tarifa. Busco: • Estructura clara y fácil de mantener para crear y administrar la hoja. • Módulo de lista de precios donde pueda agregar, quitar o editar productos sin romper fórmulas ni vínculos. • Sección de cotización que, con solo seleccionar los ítems, genere el total con impuestos, descuentos u otras variables que indiquemos. • Automatización mediante fórm...

Several large, raw Excel files need to be transformed into clear, actionable information. The core of this engagement is thorough cleaning and organizing of each sheet, followed by the creation of pivot-table-driven reports and reliable, reusable formulas. Accuracy, transparency and a neat workbook structure are essential—each figure in the final report must trace back to the source row without manual intervention. All work will be completed inside Microsoft Excel; you are welcome to employ Power Query, advanced formulas such as INDEX-MATCH or SUMIFS, and any other native tools that keep the solution self-contained. Deliverables • A master workbook with all data cleaned, properly formatted and error-free • Pivot tables and named ranges that update automatically when new...

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

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

I have a collection of Excel spreadsheets filled with numbers that must be transferred, double-checked, and neatly organized within new sheets. The work is entirely numeric—no text cleanup or database building—so a sharp eye for digit accuracy is essential. Your task is to key the numbers exactly as they appear, apply any basic formatting I specify (column widths, thousand separators, simple formulas), and run a quick self-audit before sending the file back. I will spot-check random cells, so the goal is zero discrepancies. Please let me know your usual turnaround time per 1,000 rows and any quality-control method you rely on in Excel. When you submit, I expect: • The updated spreadsheet(s) with every figure correctly entered • A short log of any anomalies you...

I need help with my google sheets program designed for comprehensive food and beverage inventory data management. The tool is to facilitate complex data import/export, edits and organization, specifically using a completed CSV file to import to my POS Software "Lightspeed" I've included the current draft and am stuck on "Pairing" #Keys in Sheet: #Keys_Bev & Inv to their corresponding Inventory items in Export_Master, pulled into Sheet #Keys_Bev & Inve, both of which have their own separate sku and item details. Key requirements include: - High skill level of Excel or Google Sheets data pulling/organizing across multiple sheets - Basic understanding of inventory data and relevance with food & Beverage Ideal skills and experience: - Advanced Excel prof...

I need a custom web application to manage sales and purchases for my trading office. Essential features include: - Sales and purchase entry forms - Individual ledgers for clients - Linked sheets for reports - Full accounting module including balance sheet in Indian standard Ideal skills and experience: - Proficiency in web application development - Experience with accounting software integration - Strong understanding of Indian accounting standards - Ability to create user-friendly entry forms and linked reports Please ensure that the application is secure and can handle multiple users. Looking forward to your proposals!

I have two existing Excel workbooks that hold mixed text-and-number datasets. I need them cleaned up, laid out consistently, and linked together so I can pull specific values from one sheet into the other with VLOOKUP (or an equivalent lookup function if you feel XLOOKUP or INDEX/MATCH suits the task better). Here is what I’m after: • Standardise column order and cell formats on both sheets so the lookup range is crystal-clear. • Build the lookup formulas that retrieve exactly the fields I specify. • Apply conditional formatting that highlights the returned values—nothing flashy, just a clear visual cue that the data has come through correctly. • Leave the file with formulas intact (no hard-coded outputs) and include a brief note explaining any na...