Macros do Excel Jobs

Very straightforward task. Create an Excel table based on the draft I'll provide. Need to add simple filters to some columns and separate columns into different sections, which could be expanded or collapsed upon clicking on them. It's important that if collapsed the title of the section is still visible so I can understand which section is hidden and I should be able to expand it once I click on the title of the "hidden" section.

I need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur. Key points you should build in: • replacing about 20 words on one wb I Should get a macro in an xlsm file that I can run on other similar files. attache a file to be changed a file with words to replace and their replacements. an instruction letter at the end I will check the macro file to see that all the replacements were executed.

I have several spreadsheets that now feel unwieldy and inconsistent. I need someone who can step in, quickly understand the structure, and turn them into clean, reliable workbooks. Here’s what I specifically need: • Data entry of new records without introducing errors • Applying the right filters so the information I need surfaces instantly • Building or correcting formulas to automate totals, look-ups, and other basic calculations You’re welcome to suggest smarter ways to structure the sheets if it will speed up future updates. If things go smoothly, I may also pass along some light photo edits and ID-card layout tweaks later, but the first milestone is all about getting these Excel files running efficiently. The deliverable is a polished workbook...

Looking for an experienced freelancer to build a formula-based Excel (.xlsx) tool that generates EDIG@S EDIFACT NOMINT messages for gas nominations. Requirements • Generate NOMINT messages (single & multi-point) • Correct EDIG@S segments: UNH, BGM, DTM, NAD, SEQ, LOC, QTY, RFF (opt), UNT • Automatic and correct UNT segment count • Excel formulas only for all EDIG@S logic (no VBA for message generation) • Optional VBA only to export the generated text to a .edi file • Clean input/output separation, ops-friendly Nice to have • Read-only viewing of CONTRL / APERAK • Simple ALLOC generation (daily only) Deliverables • Excel file + brief instructions • Sample NOMINT output MUST HAVE SKILLS • Hands-on EDIFACT / EDIG@S expe...

Build Excel Dashboards & KPI Reporting Tools We are looking for an Excel dashboard specialist to build business and performance dashboards using Excel. These dashboards will be used by managers and decision-makers for reporting and analysis. What You Will Develop You will build Excel dashboards and analytics tools, including: KPI and performance dashboards Sales and marketing dashboards Funnel and conversion tracking dashboards Summary and reporting dashboards Each dashboard will be an interactive Excel file with charts and summaries.

I need an Excel dashboard to visualize operational data, specifically focusing on procurement across different companies. The dashboard will be used for data visualization purposes. The data set is already created, along with some ref pivot tables for IDEA. just need Help with the visualization of the content along with a few addons based on requirements. The data set talks through the Procurement plans from different global regions for the next 3 Financial years with some key metrics needed to be captured for easy user/team viewing of the plan and progress Requirements: - Ability to create visually aesthetic, interactive and user-friendly Excel dashboards - Expertise in data visualization techniques - Experience with operational data analysis - Ideal Skills and Experience: - Strong a...

I have an Excel sheet that already contains options prices, futures prices and strike prices laid out in raw tables. I need a second workbook (or a re-structured copy of the same one) that automatically recognises the at-the-money (ATM) strike, computes the corresponding straddle value, and shows the ratio of that straddle to the current futures price. The file should refresh these three metrics instantly whenever I paste new daily data. The layout I have in mind is simple: source data on one tab, clean summary on another. Formulas are fine; a small VBA routine or Power Query step is welcome if it keeps the workbook fast and eliminates manual intervention. Deliverables • A working .xlsx file with clearly labelled input and output areas • Built-in calculations for:  1...

I'm looking for an Excel expert to help with report generation, specifically financial reports. The task involves creating Excel sheets from provided data to generate financial reports. Ideal Skills and Experience: - Proficiency in Excel - Experience in financial report generation - Ability to work with large data sets - Knowledge of financial metrics and statements

I need a clean, fool-proof Excel workbook that lets me roster my team by simply typing each person’s start and finish times for every shift. As soon as I enter those times, the sheet must calculate the exact hours worked that day and keep a running total for the week, all without any extra clicks or macros. What has to be captured • Start time and end time for every shift • Hours worked, calculated automatically • A live weekly total for each team member Core requirements • Manual time entry—plain cells where I can type or paste times. • Formulas only (no VBA), compatible with Office 365 and standard desktop Excel. • Clear, protected formula areas so no one overwrites the logic by mistake. • Straightforward layout I can duplica...

I need help to efficiently pair PO numbers with accounts in Excel. Currently, I do this manually using Excel functions, and I'm looking for a more effective solution. Key Tasks: - Analyze current manual process - Develop a streamlined method, potentially using Excel functions, VBA, or other tools Ideal Skills: - Proficiency in Excel, including advanced functions and VBA - Experience in process optimization - Attention to detail and problem-solving skills Looking for a solution that saves time and reduces manual effort.

I'm looking for an Excel calendar template designed specifically for daily scheduling and planning. The template should be user-friendly and customizable, allowing me to efficiently manage my daily tasks and activities. Requirements: - Daily format covering 365 days - Customizable fields for task descriptions, time slots, and priority levels - Clean, organized, and visually appealing layout - Ability to easily add, modify, and track tasks Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in creating customizable templates - Strong design skills for a professional appearance - Attention to detail and user experience Please include samples of previous Excel templates you've created.

I have a contacts worksheet in Google Sheet for Mac that often contains more than one row with the same email address. What I need is a lightweight macro I can trigger from a button or shortcut that will: • scan the sheet, • find every email that appears more than once, and • highlight each duplicated entry in red—nothing is to be deleted automatically. The highlight-only approach lets me decide, on a case-by-case basis, which full contact row to keep and which to remove. Aside from the red fill on duplicates, the script must leave every other part of the workbook untouched. Please deliver a ready-to-use VBA module (or an entire macro-enabled workbook if you prefer) that works smoothly in current Mac Google Sheets, along with a short set of installation and usag...

I need three clean, easy-to-reuse templates built in Excel: • A hiring sheet that already has columns for candidate details and position, space to log each interview’s schedule and feedback, and a final section where we record the hiring decision plus any offer details. • A weekly time sheet with rows for employee working hours, break times and any overtime captured automatically. Simple formulas that total the regular and OT hours are a must. • A productivity-hours tracker for my teachers so I can see, at a glance, how many hours each one spends on class time, prep, grading or other tasks; totals should roll up per teacher and per week. * petty cash sheet - incoming money and expenditure items and showing balance as on date * attendane sheet, where i can automati...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I have 50 pages of information locked in PDF documents that I now need clearly entered into a single Excel workbook. Nothing fancy—just clean, error-free data that mirrors what you see on each page. Accuracy matters more than speed; a small typo in one cell could throw off the entire file, so I need someone who is comfortable double-checking their own work and flagging anything that looks ambiguous. Once you receive the PDFs, please extract every data point and lay it out row-by-row in Excel so I can sort, filter, and run formulas later. If a page has obvious column structure, keep that structure intact. If it’s a paragraph or form, split the content logically across columns (I can clarify edge cases as they come up). No special template is required—the standard grid is ...

Project Description for Excel Expert ​Project Goal: I am looking for an Excel Expert to help me organize and automate my data effectively. ​Data Cleaning: The freelancer must clean raw data, remove duplicates, and fix formatting issues. ​Advanced Formulas: Expert knowledge of formulas like VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH is required. ​Pivot Tables: Ability to create dynamic Pivot Tables and Charts for data summarization. ​Automation (VBA/Macros): I need someone who can create Macros or use VBA to automate repetitive tasks. ​Dashboard Creation: Looking for a clean and professional interactive dashboard to visualize key metrics. ​Data Accuracy: High attention to detail is a must to ensure 100% accuracy in calculations. ​Data Validation: Setting up drop-down lists and data validati...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I have several Excel/CSV files filled entirely with numerical figures that I need migrated into a single Google Sheets workbook. Before the transfer, the data must be cleaned and reshaped—column headings reorganised, date and currency fields standardised, and redundant rows removed—so it lands in Sheets ready for instant analysis. You’ll work directly in Google Sheets, but you may need to manipulate the source files first in Excel (or another tool you prefer) to achieve the required structure. Accuracy is essential; formulas and totals in the final sheet should match the originals after reformatting. Deliverable: • A Google Sheets file containing all numbers from the source files, consistently formatted and fully validated. I’ll share the files and a brief m...

I need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur. Key points you should build in: • Action: word-for-word replacement (this is a data-processing task, not data entry or extraction). • Source list: multiple columns on a single sheet; assume column A holds the words to find and column B the words to insert. • Scope: apply changes to every cell in every sheet unless I later flag specific sheets to ex...

I need a lightweight Excel-based “project program” that I can open, understand and tweak without outside help. Everything—from the way data is entered to the formulas that calculate results—has to stay clear, unlocked, and easy to adjust. Here’s the feel I’m after: I type project details in one place, watch totals or status indicators update instantly, and know I can add rows or columns later without breaking anything. Macros, pivot tables or flashy charts are fine only if they remain transparent; the priority is simplicity and self-sufficiency. What I’d like back from you is an .xlsx file with: • A clean data-entry sheet • Built-in calculations clearly labeled or commented • A concise note or inline comments pointing out whe...

I’m building a streamlined payroll workbook in Excel that handles everything in one place—from manual attendance entry right through to the final net-pay figure. The file must automatically calculate basic salary, overtime, incentives, standard and optional deductions (PF, ESI, TDS), then roll these up into clear per-employee and month-end summaries. Key expectations • Robust formulas or VBA (your call) that protect against common data-entry errors and flag them instantly. • A clean, intuitive attendance tab designed for manual input; once entries are made, every other sheet should update without further touch-points. • Consolidated reports that let me see totals, breakdowns and variances at a glance. Deliverables 1. Finished Excel workbook with all...

Project Overview We are building an Excel-based automation and reporting system to track execution progress and speed across two parallel workflows: Listing optimization: - PPC advertising pipeline - The system must show status, velocity, bottlenecks, and readiness on ASIN and Cluster level, both internally and client-facing. This is a system-level automation project, not a simple dashboard. What the System Must Do: At any time, the reporting must clearly answer: - Where do we stand overall? - Which clusters are blocked or slow? - How fast is execution moving? - Is Listing or PPC the bottleneck? - How has progress changed vs yesterday / last week / last month? Core Scope (High-Level): - Derive execution statuses from raw Excel data - Track daily historical snapshots (append-only) - Cal...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results. Scope of work • Import and consolidate all source files into a single, well-organized workbook. • Remove duplicates, handle missing values, and standardize date and currency formats. • Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period. • Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs. • Provide a short writt...

I keep my monthly figures in a local Excel workbook and now need a clear, interactive dashboard that focuses on one core KPI—cash flow. I can handle basic formulas, but I’d like your expert walk-through on structuring the data model, choosing the right visuals, and automating refreshes when I drop in an updated file. No API or database connections are involved; every source stays on my machine. Here’s how I picture our collaboration: • A short call or screen-share where you review my current sheet, outline a clean data layout, and map out the cash-flow metrics. • Hands-on build of the dashboard inside Excel using PivotTables (or Power Pivot if you feel it adds value), slicers, conditional formatting, and clear charting. • Simple refresh logic so when ...

I need three clean, easy-to-reuse templates built in Excel: • A hiring sheet that already has columns for candidate details and position, space to log each interview’s schedule and feedback, and a final section where we record the hiring decision plus any offer details. • A weekly time sheet with rows for employee working hours, break times and any overtime captured automatically. Simple formulas that total the regular and OT hours are a must. • A productivity-hours tracker for my teachers so I can see, at a glance, how many hours each one spends on class time, prep, grading or other tasks; totals should roll up per teacher and per week. * petty cash sheet - incoming money and expenditure items and showing balance as on date * attendane sheet, where i can automati...

I need a streamlined way to record every inward and outward movement of stock so that my running balance is always accurate. The only details I want captured are the product name and its quantity; anything more slows my team down. My preference is to work in MS Excel because everyone here already uses it daily, yet the final sheet must be formatted so it can feed data into our existing custom billing software that issues GST invoices and e-way bills for wholesale orders. A clean CSV export or a lightweight macro that pushes the figures across will do the job—whichever you feel is the quickest to maintain. Deliverables • A ready-to-use Excel workbook with clearly separated inward, outward, and live-stock sheets, plus built-in checks that flag negative or mismatched quanti...

I have an Excel workbook that needs to turn whatever I type into structured, print-ready Reports. The idea is simple: I enter data on one sheet and, through well-planned formulas (and any clever use of named ranges or dynamic print areas you think is best), the file instantly reshapes that information into a polished layout that is ready to hit Ctrl-P without further tweaks. Content focus The Reports are meant to hold Documentations, yet I want enough flexibility so that later I can extend them to other sections such as Sales data, Employee performance or Inventory levels if needed. Please keep the formulas and any conditional formatting readable because I will maintain the file after your hand-off. What I expect as deliverables • A single .xlsx template with all formulas, page ...

I’m starting a new project and looking for support on building a structured Excel model and a short PowerPoint deck. Raw data will be provided. I’ll need help mainly with setting up formulas, XLOOKUPs (when required), and applying specific criteria that will be shared. An example of how the Excel model should look will be provided, but please note that the example is high-level, while this project will require a less detailed and granular model. In addition, a 5-page PowerPoint presentation is required. A sample structure will be shared to guide the layout and flow. Both the Excel model and PowerPoint should follow the provided examples closely. I’m happy to share samples and discuss the scope further before starting. Once agreed, the project will kick off immediately ...

Goal: Create a high-performance Excel dashboard for an audit tracker with 17k+ rows that is fully functional when shared via a OneDrive/SharePoint link. Key Technical Requirements: Data Connection: Use Power Query to import the source data. Include a transformation step to "Trim" all text columns (to fix the trailing spaces in Vendor names and Statuses). Performance Calculation: Add a custom column in Power Query to calculate "Aging" (Days from 'Date' to 'Closure Date'). If 'Status' is Pending, use TODAY() for the end date. Interactivity (Web-Ready): Do not use VBA/Macros for the dashboard navigation. Use Slicers connected to all Pivot Charts. Required Visuals: Monthly Trend Line: Count of observations by month. Vendor Comparison: Ba...

I need a sharp MIS hand to take raw operational data and turn it into clear, decision-ready information. Day to day you’ll work in Excel, mining the sheets I supply, then translating them into reports that management can read at a glance. Beyond the routine summaries, I also want fresh insight—spotting patterns, highlighting anomalies, and presenting concise trend analysis that guides our next moves. Core focus areas • Generating reports in clean, well-formatted Excel workbooks • Performing trend analysis that combines numbers with brief narrative takeaways Consistency, accuracy, and visually intuitive charts are non-negotiable. If you prefer adding Power Query, pivot tables, or VBA to streamline the flow, feel free; just keep everything compatible with standa...

Need help completing MYLABIT Excel assignments. Tasks include formulas, functions, formatting, data analysis, and following assignment instructions accurately. Looking for someone experienced with Microsoft Excel and MYLABIT projects to complete the work correctly and on time. ONLY PEOPLE WITH EXPERIENCE CAN TEXT ME NO ONE ELSE

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I need my Excel workbook opened up so I can finally see and edit everything inside it. The file is currently locked at the workbook level and its VBA project is also password-protected. I don’t need you to alter, optimise, or add any macros—just remove the protection cleanly, preserve the existing code and data exactly as they are, and send the unlocked version back to me. Deliverable: one fully accessible workbook with all workbook and VBA passwords completely removed, ready for me to work on without any prompts.

The workbook is complete from a data standpoint, but its presentation still feels rough. All content—numbers, text, and a few formulas—already sits in place; what it lacks is the polish that makes headers pop, key data points easy to spot, and total or summary rows instantly recognisable. In short, the sheet’s primary purpose is now pure formatting. Here’s what I need: • Realign every row and column so entries sit flush, wrap correctly, and no values spill over adjacent cells. • Establish a clean font hierarchy: head­ers and subhead­ers should stand out while ordinary cells remain unobtrusive. • Apply subtle borders, shading, and spacing to separate sections without adding visual clutter. • Make key figures visually distinct (condi...

I need three clean, easy-to-reuse templates built in Excel: • A hiring sheet that already has columns for candidate details and position, space to log each interview’s schedule and feedback, and a final section where we record the hiring decision plus any offer details. • A weekly time sheet with rows for employee working hours, break times and any overtime captured automatically. Simple formulas that total the regular and OT hours are a must. • A productivity-hours tracker for my teachers so I can see, at a glance, how many hours each one spends on class time, prep, grading or other tasks; totals should roll up per teacher and per week. * petty cash sheet - incoming money and expenditure items and showing balance as on date * attendane sheet, where i can automati...

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

I need an Excel expert to merge multiple calculation files into a single file and add custom calculations. Requirements: - Merge existing Excel files into one - Add custom calculations, including complex mathematical formulas - Use of differential equations is required Ideal skills and experience: - Proficiency in Excel, especially with complex formulas - Strong background in mathematics, particularly in differential equations - Experience in data manipulation and file merging in Excel

My Excel workbook contains several sheets of raw, unstructured data. I need it transformed into a clean, easy-to-read file. The job covers: • Applying appropriate cell and number formats so dates, currency, percentages, and plain text all display consistently. • Sorting each table logically (alphabetically, numerically, or by date) once the fields are cleaned; I will confirm the exact sort key with you at the start. • Removing blank rows, duplicate records, and any obvious typos that a quick pass can catch. • Delivering the final, formatted .xlsx file plus a brief note outlining the main steps you took, so I can replicate the process later if needed. The data volume is manageable—under 20,000 rows across three sheets—so I expect the whole turnaround ...

The workbook is complete from a data standpoint, but its presentation still feels rough. All content—numbers, text, and a few formulas—already sits in place; what it lacks is the polish that makes headers pop, key data points easy to spot, and total or summary rows instantly recognisable. In short, the sheet’s primary purpose is now pure formatting. Here’s what I need: • Realign every row and column so entries sit flush, wrap correctly, and no values spill over adjacent cells. • Establish a clean font hierarchy: head­ers and subhead­ers should stand out while ordinary cells remain unobtrusive. • Apply subtle borders, shading, and spacing to separate sections without adding visual clutter. • Make key figures visually distinct (condi...

Automatización de Contratos – Google Apps Script + Google Docs + PDF Buscamos un freelancer con experiencia en Google Apps Script y Google Workspace para automatizar la generación de contratos en PDF a partir de un Google Doc machote. Contexto • Existe un contrato base en Google Docs con variables (placeholders). • El contrato se modifica con frecuencia, por lo que debe mantenerse como documento maestro editable. • La automatización debe usar siempre la versión más reciente del machote. Requerimiento principal • Desarrollar una Web App en Google Apps Script accesible por URL. • Acceso solo mediante Google Login. • Restringir acceso mediante whitelist de correos autorizados (vendedores). • Usuarios no auto...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I use a daily timesheet built in Microsoft Excel, and every day my time-clock system gives me the raw “clock-in / clock-out” data. What I need is a reliable way to move those start-and-end times into the sheet and have Excel return an accurate total-hours-worked figure for each employee day after day. You would take the exported time-clock file (CSV or similar), map its fields to the correct columns in my workbook, and set up the formulas—SUM, IF, TIME, or whatever is best—so that the Total Hours Worked cell always reflects the precise duration between clock-in and clock-out. Historical data for the current pay period (roughly one month) also has to be copied in and checked for errors. Once you hand back the updated workbook, I should be able to drop in tomorrow&r...

The workbook is complete from a data standpoint, but its presentation still feels rough. All content—numbers, text, and a few formulas—already sits in place; what it lacks is the polish that makes headers pop, key data points easy to spot, and total or summary rows instantly recognisable. In short, the sheet’s primary purpose is now pure formatting. Here’s what I need: • Realign every row and column so entries sit flush, wrap correctly, and no values spill over adjacent cells. • Establish a clean font hierarchy: head­ers and subhead­ers should stand out while ordinary cells remain unobtrusive. • Apply subtle borders, shading, and spacing to separate sections without adding visual clutter. • Make key figures visually distinct (condi...

I need an Excel expert to resolve conditional formatting issues on my sheet. The current rules are not applying correctly, and I need someone to fix this so my data is displayed accurately. Ideal Skills and Experience: - Advanced knowledge of Excel - Expertise in conditional formatting - Attention to detail - Problem-solving skills

I maintain a growing warehouse spreadsheet and would like to turn the repetitive “copy-paste-filter” routine into a single-click solution. The job is straightforward: write an advanced VBA macro that reads raw inventory data from one or several worksheets and automatically produces a clean, ready-to-share inventory report each time I run it.

I have several Excel spreadsheets that need to be transferred into a consolidated, well-structured master file. Every entry must be typed in manually and then cross-checked for accuracy before final delivery. Alongside this core task, I also need brief online look-ups to confirm spellings, addresses, and other small details that may be missing, plus light document-formatting so the finished file looks clean and consistent. Here is how I see the workflow: • Receive the source spreadsheets from me and review their current layout. • Manually key all records into the template I will provide, maintaining identical column order and data types. • Verify each record once it is entered—this may involve a quick web search, a second pass through the sheet, or using simple E...