Macros de Excel Jobs

I need an Excel sheet to manage and track inventory data. The sheet should allow users to manually input data and should be able to track stock levels, generate reports, and automate calculations. Key Requirements: - Track stock levels - Generate reports - Automate calculations Ideal Skills: - Proficiency in Excel - Experience with data entry sheets - Strong understanding of inventory management

I have several Excel workbooks that need a straightforward tidy-up. All the source material is already digital, so there’s no scanning involved—just working directly in the spreadsheets I provide. Your job is to reorganize the information, apply consistent formatting, and generally make each sheet clear, readable, and ready for immediate use or reporting. Key deliverable • A single, well-organized Excel file for each original workbook, with clean headings, uniform cell styles, and properly structured tables (no stray blanks or merged-cell surprises). If you have a good eye for detail, solid Excel skills, and can turn this around efficiently, I’d like to hear how quickly you can start and your estimated completion time.

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