Visual Basic Jobs

Bitte melde dich an oder Loge dich ein um Details zu sehen.

I want custom template to be created like whats shown image, that image content is around 50% vertical height In remaining height there will be columns i will share that with you. I want this custom temples to be created. It should work in both excel and google sheets

I have a collection of physical forms that capture a blend of text and numerical information. I need every field transcribed with 100 % accuracy into a well-structured Excel workbook so I can sort, filter, and run quick summaries when the data is back on my screen. You will receive high-resolution scans of each form. Your task is to key the data directly into a single Excel file, following the column layout I will provide. Please preserve all original spellings, numeric formats, and any special characters that appear on the forms. Deliverable • One clean .xlsx file containing every record from the supplied forms, ready for immediate analysis. I will spot-check the sheet for consistency and input errors, so attention to detail is vital. If this sounds straightforward to you ...

I have three-to-four separate Excel workbooks (about 100 MB total) that track related data streams. I need a single, clean Excel dashboard that automatically pulls, merges and refreshes those numbers whenever the source files are updated. Here’s what I’m expecting: • One master .xlsx file that uses native Excel tools—Power Query, PivotTables, slicers or any technique you find best—to connect to each source workbook, consolidate the data and present it in a set of well-designed charts, tables and KPIs. • All links set up so that a simple Refresh brings in new data without breaking formulas, formats or visuals. • Clear, in-file notes (or a short PDF guide) explaining where the connections live and how to add or remove a source file in the futur...

I have a short, 250-word paragraph that I copied from another website into Microsoft Word. Since pasting it, I’m seeing odd, non-printing artefacts—little dots, stray spaces or other markers popping up after many words. I’m not sure exactly what they all are, but every trace of them has to disappear before I move the text over to IMDb. Any method that gets the job done is fine with me—manual inspection, Word’s built-in “Show/Hide ¶” tools, a quick VBA macro or an external script. All I care about is receiving a document that looks identical on the surface yet contains no hidden characters or formatting glitches underneath. Deliverables • A cleaned .docx (or .rtf) with every unwanted marker, extra space and formatting code removed &b...

I have a set of printed documents that must be keyed into a digital format with perfect accuracy. This is strictly offline data entry—I will send you scanned copies of each page, and I need every field transferred exactly as shown into my pre-formatted Excel sheet. Consistency and attention to detail are critical because the information will feed directly into our internal database once I review your file. You may use Excel, LibreOffice Calc, or Google Sheets (offline mode) as long as the final deliverable is returned as an .xlsx file with the original layout intact. Before we begin, I will provide a brief sample page so you can confirm column alignment and naming. Once that is approved, you can proceed with the remaining pages. I would appreciate progress updates halfway throu...

Saya membutuhkan bantuan menulis konten yang langsung mendorong penjualan produk dan jasa saya. Fokus utama pekerjaan ini adalah menghasilkan teks yang persuasif, ringkas, dan mudah dipahami calon pembeli. Ruang lingkup – Menyusun beberapa konsep konten; saya terbuka apakah itu artikel blog singkat, caption media sosial, atau deskripsi produk, selama terbukti mampu mengonversi pembaca menjadi pelanggan. – Melakukan riset singkat untuk memahami nilai jual unik dan pain point audiens. – Mengoptimasi judul, call-to-action, serta struktur paragraf agar menarik perhatian sejak kalimat pertama. – Menyerahkan konten final siap unggah dalam format Word atau Google Docs. Kriteria keberhasilan – Teks jelas, bebas plagiarisme, dan memakai bahasa Indonesia yang alami. &...

My workbook already asks SerpApi for data the moment I type a model number in the “Model” sheet, and Power Query pushes the results into the “Result” sheet. Two nagging issues stop it from being production-ready: 1. The cache sheet that should store the API response has stopped working, so every look-up now triggers a new, slow call instead of re-using the last fetch. 2. On the “Result” sheet the sale price reaches the correct cell, but the regular (full) price column stays empty. I need someone who understands Power Query, Excel data model, and REST/API connections (SerpApi in particular) to: • Diagnose and restore the caching logic so the workbook re-uses previously fetched JSON. • Update the query/transform steps so the full price fi...

I have an Airtable account, I need an Airtable pro who can turn my draft template into a fully functioning workspace to replace a google spreadsheet I have been using. The final base has to feel as familiar as a spreadsheet, yet still take advantage of Airtable’s relational power for contacts and their interactions. What I’ll hand over: • My existing spreadsheet/template in .csv / Airtable format • A short outline of the data I’m already tracking What I need from you: • Import and refine the template into a clear, spreadsheet-style Airtable base • Set up tables, linked records, key fields and filtered views so I can find customers in seconds • Light automation—think simple formulas, look-ups or single-step triggers—only wher...

I have over ten existing price templates that all follow the same column structure, but each one serves a different customer tier and that data needs to be inputted into the most up to date price template. I need them merged into one clean, well-organized master workbook in Excel. Your task is straightforward: enter the current pricing data exactly as provided, consolidate every template into a single sheet, and add a clear tier reference so that I can filter or pivot by customer level later. Accuracy is critical—formulas, cell formats, and any hidden calculations from the originals must carry over without corruption. If a lookup table or a dynamic named range will keep things tidy, please set that up for me. Deliverables: • One master Excel file containing every price poi...

I maintain a master price sheet (the “source” workbook) and a client-facing quote sheet (the “destination” workbook). I need the destination file to pull prices automatically from the source file through standard Excel formulas rather than macros or Power Query, so the link remains transparent and easy to audit. Inside the destination sheet the user must be able to customise a quote through: • dropdown lists that drive item selection • checkbox selections that add or remove optional services As users make choices, the relevant rows—or whole quote sections—should appear via simple drag-and-drop or copy-down actions, with all pricing fields updating instantly from the source workbook. Future maintenance is also critical. New products or pr...

Dispongo de una hoja de OpenOffice Calc donde, en cada fila, una celda contiene la URL de la foto original de una prenda almacenada en mi servidor. Quiero un macro (VBA para OpenOffice Basic) que, apoyándose en cURL, tome esa URL directamente desde la celda, recupere la imagen y genere seis nuevas composiciones: 1. Prenda en modelo – vista frontal – ambiente rural 2. Prenda en modelo – vista frontal – ambiente urbano 3. Prenda en modelo – vista frontal – ambiente de playa 4. Prenda en modelo – vista posterior – ambiente rural 5. Prenda en modelo – vista posterior – ambiente urbano 6. Prenda en modelo – vista posterior – ambiente de playa Requisitos clave • El macro debe ejecutarse desde Calc...

Bitte melde dich an oder Loge dich ein um Details zu sehen.

I have a current excel spreadsheet that i record my options trades in. I didnt' design the spreadsheet. I want to recreate the current excel spreadsheet with a couple extra things. This should be a fairly easy job since I already have the excell workbook done and just need to recreate it with a couple changes. Please let me know if this is a project you could take on. Again, this should be fairly easy with the right designer.

My current inventory spreadsheet has thousands of rows that need to be turned into a concise, interactive view so anyone on the team can spot key patterns instantly. The core task is to build, inside Excel, a robust pivot table (or connected set of pivot tables) focused strictly on data summarization of this inventory data. What I need from you is a clean-structured pivot solution that: • Refreshes flawlessly when new inventory records are added • Lets users slice results by any existing field (SKUs, warehouse, date received, etc.) without breaking formulas • Keeps the raw data untouched, with the summary living on a separate, well-labeled sheet • Includes clear, in-sheet notes so someone with intermediate Excel skills can maintain it later Please hand ove...

I need a secure Android banking app built from the ground up for Arab Bank. The core scope is clear: users must be able to manage their accounts, transfer funds, and pay bills effortlessly from their phones. To make this happen, I’ll supply API documentation for our core-banking system along with brand guidelines and sample data. Your task is to design and code the full mobile experience—clean UI, solid architecture, and encrypted communication throughout. Performance, accessibility, and regulatory compliance (PCI-DSS level practices) are non-negotiable. Deliverables • Fully functional Android app (latest stable SDK) • Source code in Git, well-commented and neatly structured • UI/UX assets (Figma or similar) • Integration layer that consumes our ...

I have a batch of numerical records that capture daily financial transactions. I need each entry checked for accuracy, consistency, and basic logic errors before the data moves into our reporting system. The work is strictly on transactions—no invoices or budget reports are involved. You will review the figures against a reference sheet I’ll supply, spot any mismatched totals, duplicate IDs, or impossible values (such as negative credits), and then return a clean file plus a brief discrepancy log. Excel or Google Sheets will be fine for the task; if you prefer to script quick checks in Python or SQL that’s welcome as long as the final deliverables remain in spreadsheet form. Deliverables • Corrected transaction spreadsheet • Separate log outlining every c...

has been praised as “digital gold,” criticized as a speculative bubble, embraced as a hedge against inflation, and dismissed as volatile and risky. Whether viewed as revolutionary or controversial, Bitcoin has undeniably reshaped conversations about money, technology, and financial sovereignty. The Origins of Bitcoin Bitcoin was introduced in 2008 through a whitepaper titled “Bitcoin: A Peer-to-Peer Electronic Cash System” by an anonymous individual or group using the name Satoshi Nakamoto. In January 2009, the Bitcoin network officially launched with the mining of the first block, known as the “genesis block.” The whitepaper proposed a radical idea: a decentralized digital currency that would operate without a central authority such as a government o...

I want a fully-automated habit-tracking spreadsheet built in Google Sheets (Excel compatibility is a plus). It has to handle well over 20 simultaneous habits and let me log results quickly from desktop or mobile. Each entry should immediately update daily and weekly summaries, calculate streaks, and feed clear visual progress charts so I can spot trends at a glance. Beyond the raw tracking, I need space to set individual goals for every habit and have the sheet flag me—through conditional formatting or lightweight Apps Script email/push reminders—whenever I fall behind. Any formulas, scripts, or named ranges you add should be clean, documented, and easy for me to extend later. Please deliver: • A Google Sheet template pre-loaded with sample data, fully functioning dashbo...

I have id information in excel spreadsheet need to gather evidence for those ids from one portal and save the evidence (screenshot) in share folder

I need a summary report created using data from my spreadsheet. The focus should be on top-performing categories, presented as totals by month. Requirements: - Utilize existing spreadsheet data - Highlight top-performing categories - Present data as monthly totals Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in report generation - Strong attention to detail and accuracy

I need an interactive Excel dashboard that turns my raw sales data into clear, weekly insights. The primary focus is tracking sales performance, so the layout must highlight both our overall sales volume and how that volume breaks down by region. Data will be refreshed every week. With that in mind, the file should be structured so I can drop in a new data dump and see the visuals update automatically—no manual re-linking or reformatting. Slicers or simple drop-down filters for date ranges and regions are welcome as long as they stay intuitive for non-technical users. Deliverables • One Excel workbook containing: – Dynamic tables feeding all charts – At least two visuals: a headline KPI card for total volume and a region-level comparison (bar, map, or s...

I need a comprehensive weekly reporting spreadsheet on Microsoft Excel for my team across Operations, Technical, and Commercial departments. The spreadsheet should track: - Tasks Delivered and Completed - Tasks Not Delivered and Reasons - Complaints answered - Outstanding tasks - etc Additionally, it should outline tasks for the next 3 and 6 months, along with any relevant comments or notes. And also make it pretty with colours The ideal candidate should have: - Proficiency in Microsoft Excel - Experience in creating structured, user-friendly reporting spreadsheets - Attention to detail and strong organizational skills

I have a straightforward data-entry job focused purely on spreadsheet management. I will provide the raw data along with the existing workbook; your task is to organise the information, enter any missing figures, verify accuracy and return a clean, fully-updated spreadsheet that matches the current structure. Accuracy is the priority, so please be comfortable with common spreadsheet functions (sorting, filtering, basic formulas) and able to spot inconsistencies quickly. Once the file is complete and double-checked, simply send back the updated version along with a brief note outlining any assumptions or issues you discovered. If you thrive on tidy rows and reliable data, this should be a quick win for both of us.

I'm looking for an experienced Power Automate developer to help automate some repetitive tasks. The goal is to save time and increase productivity. Key requirements: - Automate tasks primarily using Microsoft Office Suite and Cloud Storage Services - Focus on spreadsheet updates and document generation - Built-in manual trigger within Excel to generate a suite of documents. Ideal skills and experience: - Proficiency in Power Automate - Experience with Microsoft Office Suite, particularly Excel and Word - Familiarity with various cloud storage services - Strong problem-solving skills and attention to detail Please provide examples of similar work done and your approach to this project.

I have a growing set of customer records that must be brought into a single, reliable Microsoft Excel workbook. The work involves three clear steps: • Data entry – transfer raw customer details I provide (names, contact info, purchase history, notes) into a structured Excel template. • Data cleaning – de-duplicate, standardise phone and email formats, and flag any incomplete fields so our CRM import runs smoothly. • Basic analysis – add pivot tables and simple charts that highlight total customers by segment, recent purchase frequency, and any notable trends you spot. Everything has to stay inside Excel—no outside tools—so a solid command of formulas, data validation, conditional formatting, and pivot tables is essential. I will review the...

I need a clean, well-structured spreadsheet that focuses solely on customer purchase history, limited to the dates of each transaction. No contact details, product names, or amounts are required—just an accurate record of when every purchase occurred. Please organise the data in either Excel or Google Sheets, whichever you prefer. A separate row per transaction, with columns for Customer ID (or name if that is all that is available) and Purchase Date, will keep things straightforward. Consistent date formatting (YYYY-MM-DD) is essential so the file can be filtered or pivoted later without extra cleanup. Once complete, share the file and I’ll run a quick spot-check against our raw system export to confirm everything lines up.

I'm looking for an AutoIt script fo manual photo comparisons using two side-by-side windows with FastStone Image Viewer. Requirements: - Switch focus between the windows - Drive each window to the same photo - User manually inputs if photos are equal or not, if not - automatically move unequal photos to a specified sub-directory (pre-manual setup in FastStone viewer) - Launch and Setup of windows manual, AutoIt script gets values from .ini file. Ideal Skills and Experience: - Proficient in AutoIt scripting - Experience with window manipulation and automation - Familiarity with photo handling and directory management Here is a 1st pass at a design doc, psuedo-code. One of the reasons I am doing this with AutoIt is to get a real life sample to help me learn AutoIt coding. Require...

I'm looking for an Excel expert to create a comprehensive dashboard for managing construction projects. The dashboard should track the following key metrics: - Project Progress - Budget vs Actual Costs - Resource Allocation - Baseline vs Actual Progress - Remaining Works - Milestones - Risks The ideal freelancer should have: - Advanced Excel skills - Experience in project management, particularly in the construction industry - Ability to create user-friendly and visually appealing dashboards - Strong analytical skills to ensure accurate data representation Please provide samples of previous work.

I have several Excel workbooks that need to be transformed into clear, interactive visuals built in Power BI. The priority is comparative analysis: I want end-users to see how figures stack up against one another across products, time periods, or any other relevant dimension we identify together. At this stage I’m concentrating purely on visual exploration rather than a full narrative report or enterprise-wide dashboard, though I appreciate designs that could scale in that direction later. You will receive the raw Excel files along with a brief that highlights the main metrics to compare. I expect you to model the data inside Power BI, choose the most effective visual types, and apply slicers or drill-through where they add value. Please keep the visuals clean, performance-friendly,...

I have several months of raw sales transactions in Excel that need to be cleaned, organized, and transformed into formal financial reports. The source sheets include order dates, SKUs, unit prices, discounts, tax, and payment method details; nothing is yet summarized or categorised. Your job is to: • Tidy the data (remove duplicates, standardise date and currency formats, flag anomalies). • Build an Income Statement that automatically rolls up revenue, COGS, gross margin, operating expenses, and net profit. • Build a Balance Sheet driven by the same dataset, updating assets, liabilities, and equity as new rows are added. Both reports must stay fully formula-based—no hard-typed totals—so that I can paste next month’s sales and instantly refresh the f...

I have a collection of single-column scanned text documents that I need converted into a clean, fully searchable Excel file. The pages are almost entirely typed, but a handful contain small handwritten notes that must be captured as well. Your task is to run accurate OCR, transfer every line of typed text into logically structured spreadsheet columns, and add the handwritten snippets in a separate field or clearly mark them so I can review later. No fancy layout reproduction is necessary—clarity and searchability are what matter. Deliverables • One Excel workbook containing all extracted text, ready for filtering and formulas • Handwritten content entered or flagged in its own column • A quick quality check to ensure the spreadsheet matches the source scans Plea...

I have several Excel workbooks that already contain raw customer information, but they’re scattered across different tabs and follow no consistent structure. I need someone to consolidate every record into a single, clean master sheet, standardise the column headers, and ensure all values (names, phone numbers, email addresses, addresses, etc.) are formatted uniformly. Accuracy is critical, so I will be checking for duplicates and incomplete fields. You are free to rely on functions such as VLOOKUP/XLOOKUP, Power Query, or pivot tools—whatever speeds up the process without compromising quality. When you finish, I expect one tidy .xlsx file ready for import into our CRM plus a short note outlining any assumptions, data issues you encountered, and how you resolved them. If th...

I’m sitting on a sizeable customer-data workbook and need a sharp pair of hands to turn it into something clean, consistent, and instantly insightful—all within Excel. Here’s what I’m looking for you to do: • Data cleaning and organizing: remove duplicates, fix inconsistent labels, standardise formats, and flag any obvious outliers. • Pivot tables and charts: build dynamic pivots that let me slice results by region, segment, and purchase date, then link them to clear, presentation-ready charts. • Advanced formula implementation: craft robust formulas (INDEX-MATCH, SUMIFS, array functions, whatever is best) so key metrics update automatically when I drop in fresh data. Everything should stay inside one well-structured workbook with named ranges, ...

I have several CSV files—course lists (with numbers, requisites, labs and any concurrent pairings), faculty-preference forms in Excel, student-preference forms in Excel, and a record of which courses each instructor has previously taught. From those inputs I need a standalone scheduling tool that will: • read the CSVs directly (no manual re-formatting) • assign flexible time slots and days to every course, pairing each section with a qualified instructor such that each instructor either teach Mon/Wed or Sun/Tue/Thur but not both. • export the finished timetable as a single CSV laid out exactly like the sample I will share, showing day, start/end time, and instructor name • automatically flag overloads (any instructor teaching more than two courses) and anyone...

I need a set of automated dashboards in Google Sheets that continuously pulls data from our recurring CSV exports and turns it into a live view of company performance. The two figures I must see at a glance are Revenue and Net Profit, with the option to slice by product line and date once the basics are stable. Here is what the finished workbook should let me do: • Drop the latest CSVs into Drive and watch the data model update without manual copy-pasting. • View clean, interactive charts and tables that refresh on schedule or at the click of a button. • Export or share the P&L dashboard with teammates while keeping formulas locked down. Please build whichever mix of formulas, pivot tables, named ranges, or Apps Script you feel is best to keep refresh times f...

i want to create MS Access database sheet requirement database not to big or hard Database Requirement Explanation I belong to the Indian Army. My unit has a strength of approximately 445 personnel. Every year, individuals remain embodied (on service) and disembodied (service break) for varying periods, usually ranging from 1 to 4 months at a time. I want to create a database (preferably in MS Access) where each individual has a separate profile, and all service periods are calculated automatically. ⸻ Individual Profile Requirements Each individual profile should contain: • Army Number • Rank • Name • Date of Enrollment Example: Army No: 1245 Rank: Sepoy Name: Pankaj Date of Enrollment: 01 Dec 2015 ⸻ Embodiment / Disembodiment Logic For each individual, there can be m...

I have several Excel workbooks that need to start running themselves today. The goal is simple: turn my manual, time-consuming routines into push-button macros. The focus is on two areas: • Generating polished, ready-to-send reports from raw sheets • Cleaning and transforming data so downstream formulas, pivots, and dashboards work flawlessly Everything sits in Microsoft Excel and must be handled entirely with VBA. No add-ins or external tools are required—just clean, well-commented VBA modules that I can maintain later. I will provide the current files and a quick walkthrough of the reporting logic and data issues. From there, I need: 1. A single workbook (or a small set, if separation makes sense) containing fully automated procedures. 2. Clear triggers&mda...

I’m consolidating a collection of product details that currently live in multiple Excel sheets. Before these records move into our live system, they must be entered accurately and made analytics-ready. Here’s what has to happen: • Data cleaning & verification – detect typos, duplicate SKUs, or incomplete attribute fields and correct them. • Formatting & organizing – structure columns uniformly, apply consistent naming conventions, and ensure every record aligns with our template so the import runs smoothly. • Analysis & reporting – once the file is clean, generate a brief summary (e.g., item counts per category, missing image percentages) so I can validate data health at a glance. The final hand-off will include the clean...

I already have a working Microsoft Access file that stores classes, participants, teachers and hosts for our school-trip programme. What I need now is a set of practical refinements that will let our office staff spend less time wrestling with data and more time focusing on the children. 1. Improved data-entry and registration forms • One clean form for new trip registrations that captures student details, emergency contacts and essential medical information in a logical flow. • Auto-fill and look-ups wherever possible so teachers are not re-typing the same names or addresses each term. • A printable version of this form that doubles as the parental consent sheet. 2. Advanced reporting & export tools • A ready-to-print registration/attendance l...

I’m looking for an experienced spreadsheet designer to create a clean, modern, and easy-to-use fitness & weight loss tracker in Excel or Google Sheets. The design should be simple, beginner-friendly, and visually appealing — not overly complicated or cluttered. Think clean layout, soft aesthetic, organized structure. Required Pages: Goal Setup Page Current weight Goal weight Goal date Basic automatic calculations Weight Log Date Weight Progress tracking Simple trend chart Dashboard Overview of progress Clean, easy-to-read chart Summary metrics Workout Tracker Date Exercise Sets / Reps / Weight Habit Tracker 30-day layout Simple completion tracking Monthly Progress Summary Important: Must work well on desktop and mobile Clean formatting Automated ...

I need an Excel worksheet for monthly billing at my personal training studio. The worksheet should clearly display: - Client names - Services offered: Personal training sessions and group classes - Fixed cost per service - An option to apply credits Ideal skills and experience: - Proficient in Excel - Experience with billing or invoicing systems - Attention to detail and accuracy

I have a stack of paper documents that contain both text and numerical information. I need every line carefully transcribed and organised into a clean, well-structured Excel spreadsheet. Please keep the original order of the records, label the columns clearly, and double-check totals or calculations so the numbers match exactly what appears on the page. Accuracy and legibility are more important to me than speed, but I would like regular updates so I can spot-check your work as we go. Once complete, I expect a single .xlsx file that is ready for analysis with no stray characters or formatting issues.

We are looking for an experienced Excel automation specialist to help connect two existing Excel workbooks used in a digital media workflow: Traffic Sheet Workbook (placement-level trafficking instructions) CMW (Creative Specs) Workbook (creative details: ad names, rotation %, flight dates, etc.) Currently, these documents are separate and require manual copy/paste of data (e.g., ad names, rotation values, creative flights). We would like to implement a reliable, maintainable way for the Traffic Sheet to automatically pull select fields from the CMW. This is not a redesign of the documents — it is a structured automation enhancement. Current State CMW workbook contains multiple tabs: Standard Display Custom Units Video Audio Traffic sheet is placement-based (one row per placement...

I’m looking for an experienced Microsoft Copilot / Power Automate to help me build an end-to-end productivity automation system. The objective is to automate customer escalations, MIS reporting, fraud detection, growth analysis, email workflows, and PowerPoint creation using the Microsoft ecosystem + Copilot. ⚠️ Important: This project is time-critical and needs to be completed within this week, as all required data, formats, and inputs are already available. ⸻ Timeline (Critical) • Start: Immediately • Completion: Within 5 days ⸻ Scope of Work 1. Automated Customer Escalation Replies • Auto-reply to customer escalation emails with personalized responses • Replies based on: • Standard predefined issue types • Error screenshots attached by...

I need a sma vab in Microstation which I've started, just need add in a specific shape which I have dimensions and will need to be placedat end of line it creates but shape needs always rotate based on line. And then we need to allow to b offset shape by distance define by user and creates a copy with option to be included box

I’m looking for a skilled Excel Data Analyst to clean, organize, and analyze a sales dataset. The data is available in Excel format but requires proper structuring and detailed analysis to generate meaningful insights. Scope of work includes: - Cleaning and organizing raw sales data - Removing duplicates and correcting inconsistencies - Creating summary reports (sales by product, region, date, etc.) - Identifying trends, top-performing products, and key revenue drivers - Building pivot tables, charts, and a simple dashboard Strong proficiency in Excel (advanced formulas, pivot tables, and data visualization) is required. Please share examples of similar sales analysis projects you’ve completed.

I have seven divorce-case billing statements from my lawyer, and I need them consolidated into a single Microsoft Excel workbook that makes every inconsistency jump out at a glance. Your job is to import each statement onto its own tab, then build an analysis sheet that automatically flags: • Overcharged hours • Duplicate charges • Unusual expenses • Fraudulent billing Smart use of formulas, conditional formatting, and (if helpful) pivot tables should let me see where each new statement differs from the last and exactly how the totals shift over time. Please structure the workbook so I can drop in any additional statements later and have the discrepancy calculations update without extra work. Deliverables 1. One Excel file (.xlsx) containing: &nd...

I need a set of Excel sheets purpose-built for handling quotations. I’ll be typing in quotation details rather than running extensive analyses, so the layout has to make entering text, line items and basic figures quick and error-free. Here’s what matters to me: • A clean, intuitive structure where I can add or remove rows without breaking any formulas. • Logical sections for item description, quantity, price and total so the sheet doubles as a professional-looking quote I can send to clients. • Basic formulas that automatically extend when new lines are added, plus a final summary field that clearly shows the grand total. • Print- and PDF-friendly formatting. I’ll share a small sample of the data I’ll be entering and I’m happy to ...

I maintain a detailed tracker in Google Sheets (exportable to Excel) that now requires a tidy, professional refresh. The core file already exists; I simply need a skilled pair of hands to: • insert new records that have accumulated since our last update • clean and correct a few legacy rows where the data no longer matches source information • refine or extend formulas so totals, variance calculations, and date-driven reminders run automatically If you are comfortable adding light visual aids—quick charts, pivot summaries, or well-targeted conditional-formatting rules—that would be a welcome bonus, but the first priority is rock-solid data accuracy. Please be ready to work directly in Google Sheets, mirror the changes in an .xlsx copy, and leave concise ...