Visual Basic Jobs

I need a freelancer with active, legitimate access to a Bloomberg Terminal to extract firm-level financial data and deliver it in a clean, analysis-ready format. Scope of the work - Sample: listed companies. I will provide the list (company names, tickers or ISINs). - Period: 2015 to 2025, annual frequency. - Variables: 8 variables, Deliverables 1. One Excel or CSV file in panel format (one row per firm-year), with consistent column names. 2. A short data dictionary listing each variable, the Bloomberg field mnemonic used, the currency and the unit. 3. A log of missing or unavailable data points, with a brief note when a value could not be retrieved. Requirements - Current access to a Bloomberg Terminal (professional or university license). - Working knowledge of the Bloomberg Excel Ad...

Saya memiliki kumpulan teks yang saat ini berada di Microsoft Excel. Saya ingin data tersebut di-input ulang (atau disalin otomatis bila memungkinkan), diperiksa ketepatannya, lalu dikonversi ke dua format akhir: • Dokumen Microsoft Word yang rapi dan terstruktur sesuai template saya • File Microsoft Excel bersih dengan susunan kolom yang konsisten Pekerjaan mencakup: – Memastikan setiap baris/sel dari file Excel masuk ke paragraf atau tabel yang tepat di Word. – Menyesuaikan pemformatan (font, heading, numbering) agar hasil Word tampak profesional. – Membersihkan karakter asing, spasi ganda, dan kesalahan ejaan dasar sebelum konversi. – Melakukan pengecekan cepat untuk memastikan tidak ada data hilang atau terduplikasi. Saya menghargai k...

I have a backlog of company expense reports already formatted as individual Excel files, and I need every line item transferred accurately into my consolidated workbook. Each sheet follows the same column order, so the task is straight-forward but demands absolute attention to detail—amounts, dates, categories, and notes must match the originals without deviation. You will receive a folder with all source files plus the master template where the data should go. Simply work through each report, copy the information into the correct columns, double-check totals, and flag anything that looks out of place. Familiarity with basic Excel functions such as SUM and simple filters will help you spot and correct discrepancies quickly. When you send the completed file back, I will spot-che...

I have an exploration spreadsheet that tracks drilling results and I need a clear, interactive report built from it. The report must present BOTH a bar-chart view and an accompanying data table so users can toggle between visuals or view them side-by-side. Primary goal • Display drilling intersections of 20 m or more with grades of 2.0 g/t or higher. • Allow the same layout to work for any other length or grade a client may type in, so filters or slicers need to be parameter driven. • Break the results down by project and commodity (Gold is the example dataset). Data columns to include in every bar chart and in the table: 1. ASX Code 2. Project Name 3. Commodity 4. Project Stage 5. Project Location Area 6. Project Location State 7. Project Location Coun...

I have a collection of Excel workbooks holding mixed text-and-number fields that now suffer from inconsistent date styles, duplicate rows, stray characters, and irregular column layouts. Your task is to take those sheets and return a single, tidy version that is ready for analysis. Here’s what I need done: • Remove all duplicate or empty rows while preserving source integrity • Standardise dates, currency, percentages, and any other numerical formats • Correct common text issues such as accidental spaces, broken line breaks, or mismatched capitalisation • Align and reorder columns so each file follows the same schema • Flag any anomalies you cannot resolve and note the reason in a separate “Issues” tab You may rely on native Excel features,...

I have a working Excel file for our “Water Cooler 127” line that is starting to get unwieldy as orders grow. I need you to rebuild or refine it so every sale is captured cleanly and the numbers remain accurate at a glance. Here’s what absolutely must be in the sheet: • Customer name, full contact information, and an automatically updated purchase history tied to each client. • Product name, current selling price, and real-time stock quantity for every model we carry. I’d like the layout to stay intuitive for frontline staff, with drop-downs or look-ups where that will cut down data-entry errors. Simple dashboards or conditional-format alerts for low inventory would be a welcome bonus, but core functionality and rock-solid formulas come first. Hand-of...

I have a collection of Excel workbooks holding mixed text-and-number fields that now suffer from inconsistent date styles, duplicate rows, stray characters, and irregular column layouts. Your task is to take those sheets and return a single, tidy version that is ready for analysis. Here’s what I need done: • Remove all duplicate or empty rows while preserving source integrity • Standardise dates, currency, percentages, and any other numerical formats • Correct common text issues such as accidental spaces, broken line breaks, or mismatched capitalisation • Align and reorder columns so each file follows the same schema • Flag any anomalies you cannot resolve and note the reason in a separate “Issues” tab You may rely on native Excel feat...

I need a small automation built that sweeps through the files I work with each week, finds every date field, and forces it into the DD-MM-YYYY pattern. The main pain points are spreadsheets and text-based reports; right now team members enter dates in whatever style they like, which breaks formulas, look-ups, and scheduled mail-merges. Here’s what will make the solution a success for me: • A one-click or scheduled routine that scans existing documents and future additions. • All detected dates rewritten as DD-MM-YYYY, whether they appear in cells, column headers, or embedded text strings. • A short set-up guide so I can roll the tool out to colleagues without extra coding. You’re free to choose the technology that fits best—Excel VBA, Python, Go...

I need a streamlined Microsoft Excel dashboard that quickly turns our internal sales data into clear, insightful summaries. All information will come straight from our own systems—no external feeds—so the workbook must be structured to accept raw data exports and refresh the visuals automatically. Here is what I am after: • A single-file Excel solution (xlsx, no macros if possible) with tidy source tables, named ranges and a refresh button. • Dynamic charts, pivot tables and slicers that highlight revenue, units, average order value and year-over-year growth. • A top-level summary page that executives can read at a glance, followed by drill-down views by product, region and salesperson. • Clean, corporate-ready formatting and color-coding that matches...

My crusher-manufacturing operation needs a straightforward way to get our technical data sheets into the system the moment they leave the shop floor. Every sheet ends up as an Excel file, and I want to remove the manual upload step entirely by capturing them with a smartphone camera and having them appear in our shared folder or database automatically. Here is the flow I’m envisioning: a worker points a phone at the printed sheet, hits one button, and the image is processed, converted (if needed), and stored as the original Excel file in the correct destination with a time stamp. Any basic cropping or perspective correction should happen in the background so the data is clean. We work in a dusty environment, so the solution needs to tolerate imperfect lighting and occasional smudges...

I have a collection of PDF files that contain strictly numeric information—no text fields, just figures that need to be captured exactly as they appear. My priority is accuracy; an automated scrape won’t cut it because occasional formatting quirks in the PDFs throw off OCR. I’m looking for someone who will open each file, verify every number by eye, and input the data manually into a clean, analysis-ready spreadsheet. You are free to work in Excel or Google Sheets—whichever you prefer—and I’m happy to export the final table to CSV or another standard format once the numbers are confirmed. Just let me know your preferred workflow up-front so I can stay consistent on my end. Acceptance criteria • Every numeric value transcribed without alteration ...

I have a collection of CSV files that need to be imported quickly and accurately into a master Excel workbook. The job is strictly Excel-focused, centering on clean data entry rather than formulas, macros, or analysis. Here is what matters to me: • Each CSV file must be opened, reviewed for obvious errors (such as misplaced delimiters), and then copied into the correct worksheet tab without altering field names. • Numbers stay as numbers, dates retain their original format, and text strings remain untouched—no unintended auto-formatting. • Final delivery is a single .xlsx file that mirrors the structure of the source files and passes a spot-check for 100 % accuracy. I usually handle Word and PowerPoint tasks myself, but familiarity with those apps would be a ni...

I have a batch of PDF files laid out in neat, table-style columns. Every image that appears—whether it sits in a header cell, a product row, or a footer—needs to be pulled out cleanly and loss-free. Your task is to: • Save each image as an individual PNG (or high-quality JPG if transparency is absent) using a tidy, logical file-naming convention that ties back to the source file. • Build a companion Excel/CSV sheet. For every saved image, note the original PDF name, page number, table/row reference if visible, and the exact file name you created. Consistency is critical: no skipped graphics, no duplicate captures, and no down-sampling. If an image is repeated across pages, record it once and flag its additional appearances in the sheet. I’ll provide the PDF...

I have a long-running Visual Basic application that functioned perfectly until I migrated its back-end from one SQL Server instance to another. The schema, tables, and data definitions remain unchanged, yet the moment the app points to the new SQL Server database it throws a null-reference error and halts. Point it back to the original database and everything works, so the fault lies somewhere in how the code interacts with this new connection. Your task is to trace and eliminate that null error. I will supply the source code, the existing connection details, and access to both the old and new SQL Server databases so you can compare behaviour side by side. Once the fix is in place the program must compile and run without exceptions on the new database and continue to operate as it always ...

I have a series of PDFs that contain both text and numerical fields. Your task is to move that mixed data into a single Excel workbook, matching the exact order it appears in each source file. Basic formatting is all that’s needed—clean column alignment, consistent number formats, and clear header rows—no advanced formulas or styling. Accuracy is critical; what is on the PDF must land in the right cell without omissions or transcription errors. When you finish, I expect a .xlsx file that mirrors every page of the PDFs and is ready for immediate internal use.

I have a collection of raw product lists that must be transformed into a clean, easy-to-navigate Excel workbook. Your core task is simple but critical: enter all supplied product data and sort every record in strict A-to-Z order. No other cleaning steps are required this time—just accurate alphabetical organization. You’ll receive the files as soon as we start. Please work in Microsoft Excel (any recent version is fine) and keep all column headers exactly as provided. Deliverables • One .xlsx file containing the complete product list, perfectly sorted in ascending (A-Z) order. • Basic, tidy formatting—uniform column widths and clearly defined headers—so the sheet is immediately usable. • A brief note highlighting any obvious data issues you ...

I have several Excel sheets that need to be consolidated, and I want every cell transferred manually rather than through automated scripts. The files contain a mix of text descriptions and numerical values, with each row following a consistent column order. Your task is to copy-paste—or re-type when necessary—the information into a single master spreadsheet that I will share at the start of the project. Accuracy is more important to me than speed: totals must match, text must remain verbatim, and no formulas should be carried over. I will provide a brief style guide so you know how to handle blank cells, date formats, and any special characters. Deliverable: • One clean, fully populated master workbook that mirrors the original column structure and passes a quick random ...

I need an Excel Macro to reformat an existing spreadsheet. The macro should modify the spreadsheet to display user input fields. Requirements: - Display user input fields as text fields. Ideal Skills & Experience: - Proficient in Excel and VBA - Experience creating Excel macros - Attention to detail

I have a Microsoft Excel workbook that has grown messy and it now needs an immediate refresh. The sheet contains duplicate rows, inconsistent cell formats, and several columns that should be locked down with proper data-validation rules. Your main objectives are to: • Identify and eliminate every duplicate record without affecting unique data. • Standardise cell formatting—numbers, dates, text cases—so everything is consistent throughout the file. • Apply clear, reliable validation rules (drop-downs, restricted ranges, error prompts) to stop bad entries going forward. Please return a fully cleaned version of the file along with a brief note outlining the changes you made, so I can trace the logic if needed. Speed is critical—I’d like this ...

I’m looking for a specialist who can turn my existing Microsoft Excel files into a reliable, easy-to-update progress-tracking system for my projects. My main objective is to see at a glance what has been completed, what’s running behind, and where I should re-allocate attention. Here’s what I need from you: • Design or refine worksheets so tasks, dates, owners, and status flow logically and remain error-free. • Build automated calculations (percent complete, variance vs. baseline, critical milestones). • Add clear visual cues—conditional formatting, traffic-light indicators, or charts—that instantly flag delays or risks. • Create a concise dashboard summarising overall project health and drilling down to individual task level. &bul...

I have several spreadsheets that need to be brought together into one clean, well-structured workbook. Your main focus will be migrating data from multiple sources, merging overlapping tables, and resolving any inconsistencies along the way. Here’s what I’m after: • Collect each source file, import it into Microsoft Excel (CSV, XLS, or XLSX). • Map columns so that naming, order, and data types line up across all sheets. • Remove duplicates, fix obvious entry errors, and flag any anomalies you’re unsure about. • Deliver a single master sheet (or an organized set of linked sheets) that can serve as a lightweight database for future reporting. • Provide a brief log of the steps you took so I can trace any changes. I work almost entirely...

I need a straightforward spreadsheet that lets my team capture text-based records and automatically places each entry into its correct category. The layout should be clean and distraction-free, so anyone can open the file and start typing without extra instructions. The categories themselves will be fixed, visible at a glance, and ideally colour-tinted or otherwise separated so entries never end up in the wrong spot. Simple drop-down selectors or protected cells that guard headers from accidental edits are welcome, but please keep formulas and formatting lightweight—clarity is more important than bells and whistles. You may build it in either Google Sheets or Microsoft Excel; just make sure I can copy or download the finished file and use it immediately. If shortcuts or data-valid...

I have a set of PDFs where the information I need sits neatly in two side-by-side columns. I only require the text—no images or tables—and I want every line transferred into a clean, well-structured Excel workbook. Each column from the PDF should map to its own Excel column so I can filter and sort without extra cleanup on my end. Please tell me exactly how you’ll tackle the extraction, the tools or scripts you plan to employ (Python, VBA, Adobe SDK, etc.), and how long you’ll need for a first sample. A concise, detailed project proposal that shows you understand column-based parsing will help me choose quickly. Deliverable: • An .xlsx file that mirrors the original PDF layout line-for-line, column-for-column, ready for immediate analysis. I’ll provide...

Project Description I am looking for an experienced Microsoft Excel freelancer to help develop a professional Excel-based solution for data management, reporting, and analysis. Scope of Work: * Excel data cleaning and formatting * Advanced Excel formulas and functions * Pivot Tables and Pivot Charts * Interactive dashboards and KPI reports * Data analysis and automated reporting * Conditional formatting and data validation * VBA macros or automation, if required * User-friendly and professional report layout Required Skills: * Advanced Microsoft Excel * Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH * Power Query and dashboard development * Data visualization and reporting * VBA and macros (an advantage) Deliverables: * Fully functional Excel workbook * Automated reports and dashboards,...

أرفقت جدول الكميات الكامل لمشروع مختبرات داخل المملكة وأحتاج إلى مهندس تكاليف متمرس في السوق السعودي ليضع تسعيراً دقيقاً لكل بند بالريـال. سأعتمد عليك بشكل خاص في ضبط أسعار الأعمال الميكانيكية والكهربائية بما يعكس أحدث أسعار أنظمة التكييف، التبريد، القوى، إنذار الحريق، والتيار الخفيف المتداولة حالياً. ما أحتاج استلامه هو ملف Excel (أو مخرجات CCS Candy) يحوي: • سعر الوحدة وإجمالي كل بند شاملاً التوريد والتركيب والاختبارات والتشغيل. • تحليل تفصيلي يكشف مكونات السعر من مواد، عمالة، معدات، ومقاولي باطن. • جدول منفصل يمكن تعديل نسب المصروفات غير المباشرة، الاحتياطيات، وهامش الربح فيه بسهولة. • عروض أسعار موثّقة من الموردين لجميع البنود المتخصصة والرئيسية، مع ذكر مصدر السعر وتاريخه. إذا كانت لديك خبرة فعلية مع مشاريع المختبرات، معرفة مورّدين محليين، وقدرة على تسليم ...

I have a collection of raw information that must be typed into an organised Excel spreadsheet. Accuracy is critical, so I want each column protected by sensible data-validation rules—drop-downs where categories are fixed, date limits where timelines matter, and automatic alerts for anything outside expected ranges. The work is purely data entry: no formulas, summaries, or analysis are required beyond the validation layer. As soon as the sheet cleanly accepts every record without triggering an error, the task is complete. Deliverables • Completed Excel file populated with all supplied records • Validation rules documented on a second tab for quick reference If you are comfortable setting up and using Excel’s built-in validation tools while entering data qu...

I have a stack of handwritten notes that record our current product inventory—item names, SKUs, quantities, and prices. I need every line transferred into a single, well-structured spreadsheet that I can sort, filter, and share with my team. Your task is straightforward but demands care: read the handwriting, key the information quickly, double-check it for errors, and return one consolidated sheet. I work comfortably in both Microsoft Excel and Google Sheets, so you may use whichever platform lets you work fastest and most precisely. To keep things uniform, please follow the column order I will provide (Item Name, SKU, Quantity, Unit Price, Notes). Watch out for duplicate SKUs or obviously incorrect quantities—flag anything that looks off so we can resolve it before final de...

I have a set of figures that need to live in one clean, well-structured Excel workbook and then be transformed into a single, polished bar graph that compares six to ten categories. After you key the data into Excel, I’d like you to style the sheet for clarity—consistent number formatting, named ranges, and easy-to-read headings—so anyone opening the file can understand it at a glance. From there, please design a visually striking bar chart (the only chart type I need) that highlights category-to-category comparisons. Thoughtful colour choices, legible axis labels, and an unobtrusive legend are important; the goal is to make differences pop without overwhelming the viewer. Feel free to use Excel’s built-in chart tools or Power Query/PivotChart features if they spee...

I am looking to have a single Google Sheet that lets my company run day-to-day operations without jumping between multiple files. The sheet should give us dedicated areas for inventory tracking, employee scheduling, and sales / revenue reporting, then pull everything into a clean summary dashboard so we can spot issues or trends at a glance. Here is what I have in mind: • Separate, well-labeled tabs for Inventory, Scheduling, Sales, and an executive Dashboard. • Built-in formulas, data validation, dynamic charts, and pivot tables that update automatically as we add new rows. • Conditional formatting or simple Apps Script triggers (email or cell-colour alerts are fine) whenever stock dips below reorder levels, shifts overlap, or sales targets are missed. • Drop-do...

I need 100-500 customer records transferred into a single, well-structured Excel sheet. Each row should include the customer’s full name, complete contact details, purchase history, plus address and demographic information. I will provide the source files (PDF invoices and a small CRM export) and a starter workbook so you can see the column order I have in mind. Please keep everything on one worksheet, using clear column headers and consistent date, phone and currency formats. Before sending the final file, run a quick duplicate check and make sure every mandatory field is filled—accuracy is far more important to me than speed. Deliverable: • One Excel workbook (.xlsx) with all customer data entered and validated I’m ready to share the materials as soon as we agre...

I have a set of raw financial figures that I need turned into clear, reliable spreadsheets. The end result should let me track a working budget, monitor expenses in real time, and analyse income trends without having to touch the underlying formulas each month. To make that happen, each sheet must already include: • Built-in SUM and AVERAGE calculations so totals refresh automatically • VLOOKUP and HLOOKUP references that pull numbers from supporting tables when I add new rows • At least one Pivot Table that summarises the data by category and by month, ready for quick filtering I will supply the source data and a short outline of the preferred column headings; you organise it into separate tabs for Budget Tracking, Expense Reporting, and Income Analysis. Everyth...

I need an Excel workbook to consolidate 8 SMART goals. Each goal should reside on separate sheets, maintaining standard formatting. Requirements: - Create an Excel workbook - 8 SMART goals on separate sheets - Standard formatting Ideal Skills: - Proficiency in Excel - Experience with SMART goal creation - Attention to detail for standard formatting

I need help whipping a large Excel spreadsheet—well over twenty columns—into shape so it’s ready for analysis and reporting. The file is already in .xlsx format; the work is purely about tidying what’s inside it, not migrating it from another source. Here’s exactly what must happen: • Remove duplicates so each record is unique. • Correct obvious data errors—typos, misplaced values, or broken formulas. • Standardize formats for dates, numbers, text casing, and any other inconsistent fields. Once the cleanup is complete, send back: 1. The fully refreshed spreadsheet, ready for immediate use. 2. A brief changelog or summary sheet that notes the main fixes you performed (helpful for audit purposes). If you use Power Query, VBA, or...

I have a plain text data file that needs to be transformed into a tidy Excel worksheet. The work is very focused: • Import the raw text. • Remove every duplicate row so only unique records remain. • Replace each missing value with the single placeholder I will provide once we start (feel free to suggest the best way to flag it so it’s easy to filter later). The final deliverable is a single .xlsx file with clean, de-duplicated data and no empty cells. I will test it by running COUNTBLANK and checking for duplicate counts, so please be sure your script or method catches everything. Any approach is fine—Python (pandas), Power Query, Excel VBA, or your preferred tool—as long as the result meets the criteria above and you can briefly explain your steps...

I have a batch of mixed text-and-numerical records that need to be keyed into a fresh Excel workbook, strictly ordered by date. After the entry phase I want the sheet transformed into a professional, easy-to-scan resource. Here’s what the finished file must include. • A structured Excel Table that expands automatically as I add rows • At least two clear charts drawing directly from that table to visualise key trends • Conditional formatting to highlight outliers, duplicates and any negative values • Custom fonts, header styles and cell colours that follow the simple brand palette I’ll share Everything should remain within standard Excel 365 features—no macros or add-ins—so the file stays lightweight and compatible for my team. I’ll...

I will supply a folder of scanned images that contain both numeric figures and accompanying text notes. Your task is to key everything into a clean, well-structured Excel workbook. Each row in the sheet should mirror the original order of the documents, with separate columns for every numeric field and its related descriptive text. A light layer of quality control is important to me. Please run basic validation as you work—double-check simple totals, watch for obvious typos or misplaced decimals, and flag any illegible characters in a comments column. Deliverable • A single Excel file, neatly formatted, fully populated, and saved in .xlsx format. Once returned, I will spot-check a sample of entries; consistent formatting and the absence of basic errors will be the acceptanc...

I have a set of purely numeric records coming from a database export that now need to live in Excel. The raw file arrives cleanly but the way it is laid out doesn’t match the reporting flow I use, so I’m looking for someone to import the data and reorganize it into a custom structure that I will outline (it differs from a standard flat table or pivot view). You’ll pull the export directly into Excel, create the new sheet layout, populate the fields, and make sure formulas, named ranges, and formatting all work flawlessly after the reshuffle. Accuracy is critical because the workbook feeds into other models. If you’ve worked with large numeric datasets and are comfortable tailoring sheet designs, this should be straightforward. Please let me know your turnaroun...

I have several unstructured text lists—pulled from emails, notes, and plain-text files—that need to be cleaned up and organised in a single Excel spreadsheet as soon as possible. Every line of text must be placed on its own row, with clear, logical column headings added where they’re missing. Please remove stray line breaks, tidy spacing, and flag any duplicates instead of deleting them. The finished file should be a straightforward .xlsx document that opens flawlessly in Excel 2016 or later, with no macros or complex formatting. Deliverable: • One fully formatted Excel spreadsheet containing all text entries, ready for immediate use. A first draft within 24 hours would be ideal so I can review and provide quick feedback. I’ll stay available on chat fo...

I want an Excel workbook that lets me track live data in real time To make that possible, build a streamlined input panel—simple text boxes or drop-downs—so I can feed data quickly . Behind the scenes the workbook must hold the formulas and any VBA needed to keep the table live and automatically roll the numbers forward over overs and innings. Deliverables • A ready-to-use Excel file (.xlsx) with protected formulas and an unlocked input area Acceptance I will test the sheet during a short mock innings; if the three stats update instantly and the reset works, the job is done.

An Excel 2021 workbook containing critical data is currently locked behind a forgotten password and protected with AES-level encryption. I need full access to every sheet, formula, macro, and embedded object inside the file as soon as possible. Scope of work • Bypass or recover the existing password while preserving all file content and formatting. • Provide either the unlocked .xlsx file or the exact password—whichever is faster. • Confirm that the workbook opens normally in the latest Microsoft 365 / Excel 2021 environment, with no residual protection. Please let me know: 1. Your proven approach or toolset for handling Excel 2021 files with AES encryption. 2. An estimated turnaround time (speed is critical). 3. Your fixed service fee for this one-off recove...

Set up macros on SofaBaton U2 universal remote for home theatre. Devices include Samsung TV QN75Q9FNA, Denon AVR-S920W, Apple TV A1842, Technicolor DVR 9865HDC, and Panasonic Disc Player DMP-BD60. The freelancer must also provide clear instructions or a walkthrough to ensure ease of use for the client.

I have fewer than ten PDFs that contain text-only tables and paragraphs which must be transferred into an Excel workbook. Accuracy is paramount: every character from the source files has to appear in the spreadsheet exactly as written, without typos or omissions. I will provide a sample file and a template that shows the exact column order, cell merging, font style, and header formatting I need. Follow that layout for each remaining file so the final sheets line up perfectly for later consolidation. The workflow I expect: • Open each PDF, copy or OCR the text if required, and paste it into the designated Excel columns. • Apply the template’s styles—headings, bold labels, wrapped text, and any conditional formatting already built into the sample. • Double-ch...

I have a collection of text-based information that must be entered manually into an Excel workbook and then reviewed for basic insights. The work is straightforward but accuracy is critical. Here’s what I need from you: • Transfer all supplied text data into the predefined Excel template, keeping original spelling, capitalization, and line breaks intact. • Double-check each entry against the source files to eliminate typos or omissions. • Once the sheet is complete, run simple analyses—word counts, frequency tallies, or any quick pivot tables that help me spot patterns at a glance. • Deliver the finished spreadsheet and a brief summary sheet outlining notable findings. No macros or automated tools are required; this is purely manual data entry and li...

I need an automated Excel-based stock register tailored for a garment manufacturing company. The register should manage raw materials, finished goods, and job work processes. It must include a summary with automated calculations and dynamically update changes across sheets when selecting products with different sizes. It should also track materials sent for stitching (including packing materials), record items received back after stitching, and manage sales of finished goods. The solution should be user-friendly and efficient for inventory management.

I need all numeric fields currently stored in a series of Hindi-labelled online spreadsheets moved into a structured Excel file that I will supply. The task is strictly numbers—no text cleanup—so accuracy, correct cell placement, and preservation of any decimal formatting are paramount. You’ll access each online sheet, copy the values into the matching columns of my template, double-check totals with the built-in formulas, then return the finished .xlsx file. Deliverable • Completed Excel workbook with every number from the source sheets correctly transcribed and all formula checks passing 100 %.

I have a raw sales data set that must be transformed into a clean, insightful revenue report delivered in a single Excel spreadsheet. The focus is exclusively on sales data, with revenue as the sole metric to track and visualise. The workbook should: • pull the data into structured tables, • calculate total and segmented revenue with clear formulas or pivot tables, • include slicers or drop-downs so I can filter by date, product or region, and • present a concise summary sheet featuring key charts that update automatically when the underlying data changes. Please build everything natively in Excel—no external BI tools—so the file remains fully editable. Accuracy, transparent calculations, and a layout that lets a non-technical user follow the logic...

I have a worksheet built in Excel 2010 where all dates will be typed in by hand. I need every number that represents a date to appear automatically as DD/MM/YYYY, regardless of how the user writes it during entry. A clean, reliable solution that works natively in Excel 2010 is essential—power-query or dynamic array techniques from newer versions won’t run here. Please adapt the file (or provide a small VBA routine, custom format, input mask, or data-validation rule) so that: • any date input is instantly shown as DD/MM/YYYY • no accidental text or U.S.-style MM/DD confusion can slip through • the fix remains stable when the workbook is shared between different PCs running the same version Deliverables: • updated workbook or code module ready to drop ...

I have several Excel workbooks that track daily sales and purchase activity. I need a specialist who can turn this raw data into meaningful MIS outputs—cleaning what is there, analysing it for trends, and presenting the results in interactive dashboards that management can use immediately. Your core tasks will be: • Import and organise the existing Excel-based data so calculations remain automated when new rows are added. • Perform thorough trend analysis on both sales and purchasing figures, highlighting seasonality, growth patterns and any anomalies that deserve attention. • Build visually clear dashboards (Power Query / PivotTables / slicers / charts) that let users drill from a high-level view down to individual transactions. Acceptance criteria: • All f...

I have product-detail inventory records stored in a database and I need them transformed into a clean, analysis-ready Excel workbook. Every numerical field—prices, dimensions, weights, reorder points—must follow one consistent format and unit, with invalid or mismatched entries corrected or flagged. I’ll share the database export and the column-naming convention I already use; your task is to extract, standardize and lay everything out so the sheet is immediately usable for look-ups, pivots and reporting. Deliverables • A single .xlsx file containing all product-detail inventory data, fully standardized • A brief changelog or notes sheet summarising the validation rules, assumptions and any issues found Accuracy and consistency are critical. If you prefer ...

I have a batch of mixed information that needs to be organised quickly and accurately in Excel. The text portions will be gathered from specific online sources I provide, while the numerical values come from recent survey responses. Your task is straightforward: copy-paste or type the content into the spreadsheet I supply, keep every row aligned with its matching survey record, and apply basic formatting so everything is easy to read and filter later. No analysis is required—just clean, error-free entry with consistent column structure, correct data types, and simple validation where it helps (e.g., drop-down lists for categorical answers, number format for scores). A brief spot-check for obvious discrepancies before you hand the file back will be appreciated. Deliverable: one ...