Excel VBA Jobs

I have a batch of Excel spreadsheets that need attention. The files contain mixed-quality data collected from different sources, and I want them professionally cleaned and organised so I can run reliable reports without spending hours hunting for errors. Here’s what I need from you: • Identify and remove duplicate rows so each record is unique. • Re-organise the data into consistent, clearly labelled columns (some sheets will require inserting or merging columns to match a master layout). • Apply the necessary formulas where helpful—for example, automated totals or validation checks—to keep the sheets error-resistant. Every spreadsheet you return should be tidy, consistently formatted (fonts, cell styles, date/number formats), and ready for immedia...

I’d like my current Excel rota transformed into a clean, automated workbook that practically manages itself. Right now dates are out of order and shifts run together; I need everything sorted chronologically with each shift clearly separated so I can scan the week in seconds. The file must keep one critical data point—employee names—at its core, because every formula will rely on that. As soon as I enter a start and end time I want the sheet to calculate the shift length and each employee’s running monthly total automatically. If two people accidentally overlap or a shift doubles up, conditional formatting should light it up straight away. Presentation matters too. Please apply a single, professional font across the workbook; beyond that I’m not fussy about ...

I’m working with an Excel rota that has become unwieldy and hard to trust. I need you to reorganise it so every working day appears in chronological order, start- and finish-time columns calculate shift length automatically, and monthly hour totals are ready at a glance. Please separate the data by shifts (not by clients or locations) so each type of shift is simple to scan and edit. Because I frequently adjust start or finish times, all totals must update instantly through robust formulas, not manual entry. A key requirement is highlighting any scheduling conflicts; the moment two shifts clash I want clear conditional-formatting alerts so I can spot and fix issues right away. While you’re streamlining the layout, keep the original information intact—just tidy th...

I have between one and five CSV files containing purely text fields that I want moved into a single, well-structured Excel workbook. While the move itself is straightforward, I also need basic cleaning carried out along the way—think trimming leading/trailing spaces, normalising simple text inconsistencies, removing blank rows, and ensuring each column retains a consistent header. Once the import and tidy-up are finished, please deliver the final .xlsx file with the cleaned data sitting on clearly named worksheet tabs (one tab per source file is fine). I would also appreciate a short note describing any issues you spotted and the steps you took to correct them so I have a quick audit trail for future reference. If you work comfortably with Excel formulas, Power Query, or similar to...

I have between one and five CSV files containing purely text fields that I want moved into a single, well-structured Excel workbook. While the move itself is straightforward, I also need basic cleaning carried out along the way—think trimming leading/trailing spaces, normalising simple text inconsistencies, removing blank rows, and ensuring each column retains a consistent header. Once the import and tidy-up are finished, please deliver the final .xlsx file with the cleaned data sitting on clearly named worksheet tabs (one tab per source file is fine). I would also appreciate a short note describing any issues you spotted and the steps you took to correct them so I have a quick audit trail for future reference. If you work comfortably with Excel formulas, Power Query, or similar to...

I have an automated Excel-based rostering workbook that has been running in production for a while, but a few critical pieces now need attention. The core of the job is to refine the calculation logic. Some totals are coming out wrong, a couple of edge-case rules were never coded, and overall processing speed has slipped as the file has grown. I would like the existing formulas/VBA adjusted so every shift, allowance and overtime rule reconciles accurately, a set of new business rules is added, and execution time is brought back to an instant feel. Alongside that, I need the import/export module expanded. At present it handles only a basic CSV; I want to introduce two additional formats (one XLSX template we use with payroll and a JSON summary we send to Power BI). Clean, reliable parsi...

Necesito apoyo recurrente en una cuenta de Mercadolibre Empresarial para mantener al día la información de productos mediante archivos CSV/Excel. Requisitos: - VIVIR EN BOGOTA O TENER DISPONIBILIDAD PARA LA CREACION DE ACCESOS INICIALMENTE Y ALGUNA REUNION EN CASO DE REQUERIRSE. - TENER LA DISPONIBILIDAD Y AUTORIZAR DATOS PERSONALES PARA LA CREACION DE LOS ACCESOS COMO RECONOCIMIENTO FACIAL Y ESCANEO DE DOCUMENTO DE IDENTIDAD. - CUMPLIR REALIZANDO LA TAREA CORRESPONDIENTE CADA SEMANA. Tu principal responsabilidad será descargar las bases de datos actuales de la plataforma, actualizarlas localmente y volver a cargarlas sin errores. En concreto: • Importación/Exportación de datos desde mercadolibre a google drive • Control de integridad: ve...

A spreadsheet with detailed instructions is attached, and I need the entire assignment completed exactly as outlined there. The work involves three core pieces: • Data entry – copy the raw values into the correct sheets and ranges without altering formatting. • Formulas and calculations – build dynamic formulas (SUMIFS, VLOOKUP/XLOOKUP, pivot tables if specified) so every total, percentage, or lookup updates automatically when source data changes. • Creating charts – generate the charts requested in the file, styling them to match any colour or layout cues already present. Please keep every worksheet structure intact, add only the cells or tabs the assignment explicitly calls for, and double-check that all formulas return the same answers shown in the...

I have a 50-page PDF that contains plain text only. I need every bit of that text transferred into a single-column Excel sheet. Each new logical section in the source should begin on a new row, and the first row for every section must use bold formatting so the headers stand out at a glance. Accuracy is critical; the Excel file has to mirror the PDF’s wording character-for-character—no omissions, no added spaces, and no spelling changes. I will spot-check for consistency before signing off. Deliverable: one .xlsx file completed to the above standard and ready for immediate use.

I have a PDF that holds between six and fifteen data tables, all of which include merged cells and other tricky formatting choices. I need every table reproduced in a clean, fully-editable Excel workbook, preserving column order, row hierarchy, and any subtotals exactly as they appear in the source. Please separate each original table onto its own worksheet, keep header styles consistent, and avoid hard-coding values where formulas belong. I will check the file by spot-verifying totals and by running sort and filter commands, so the sheet must behave like a native spreadsheet rather than a pasted image. You may use Adobe Acrobat, Power Query, Python (tabula-py, camelot), or simply meticulous manual entry—whatever delivers an error-free XLSX. Just let me know your preferred appr...

I have a 50-page PDF that contains plain text only. I need every bit of that text transferred into a single-column Excel sheet. Each new logical section in the source should begin on a new row, and the first row for every section must use bold formatting so the headers stand out at a glance. Accuracy is critical; the Excel file has to mirror the PDF’s wording character-for-character—no omissions, no added spaces, and no spelling changes. I will spot-check for consistency before signing off. Deliverable: one .xlsx file completed to the above standard and ready for immediate use.

Saya mencari bantuan untuk “Editing dan Microsoft Office Excel,” dengan fokus utama pada “Data input dan pemrosesan.” Tugas inti: • Memasukkan data mentah ke dalam lembar kerja yang sudah saya siapkan. • Memeriksa, membersihkan, dan memvalidasi setiap entri agar bebas kesalahan. • Menambahkan rumus, fungsi, atau pivot table sederhana untuk otomatisasi perhitungan dan ringkasan data. Hasil yang saya butuhkan adalah file Excel yang rapi, terstruktur, dan langsung siap dipakai untuk laporan lebih lanjut. Apabila Anda juga mampu menata format atau menyisipkan grafik dasar, silakan sebutkan; itu bonus bagi saya. Sertakan contoh proyek sejenis dan estimasi waktu pengerjaan. Saya ingin memulai secepatnya—terima kasih!

I have several digital Excel spreadsheets that contain blocks of text which need to be transferred accurately into our master file. Your job is to open each spreadsheet, copy or re-type the text into the corresponding fields I will provide, and double-check that every character matches the original. Please keep the existing spelling, punctuation, and line breaks exactly as they appear. Any obvious typos should be flagged in a separate note rather than corrected on the fly—content fidelity is more important than editing. Deliverables • A consolidated master file with all text correctly placed • A brief log noting any unreadable cells or issues you encounter Acceptance criteria • 100 % of rows present in the final file • No mismatched or truncated t...

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I have a batch of PDFs where all the information I need sits neatly inside tables. Every cell in those tables contains text only—no numbers, formulas, or special characters. Your task is to copy that text into an Excel workbook, keeping each table’s row-and-column order intact but using simplified, clean formatting rather than trying to mirror the PDF’s exact look. Essential points • Source content: text-only tables in PDF files • Target file: a single .xlsx workbook (one sheet per PDF, unless a different layout proves clearer) • Formatting: standard font, consistent column widths, no borders or shading beyond Excel’s defaults Please double-check that every table entry is captured and appears in the correct cell. Spelling must match the origin...

I have an Excel spreadsheet filled with traveler details. Your task is to take that file, follow the step-by-step method I’ll demonstrate inside the Travel Line mobile app, and create a unique customer ID for every traveler. The workflow is straightforward once you see it in the app: • import or copy each row’s data, • apply the in-app ID-generation steps exactly as I show, • note each finished ID back into the Excel file. Accuracy and consistency are critical—every ID must be accepted by the app with no duplicates or spelling errors. When the list is complete, return the updated spreadsheet and a quick confirmation report summarizing how many records were processed and any issues you encountered. Remote screen–share training takes about t...

I have a set of PDFs that contain well-structured tables. I need every piece of text and numerical data from those tables brought into a clean Excel workbook, then enhanced with advanced formatting so the file is ready for immediate analysis. Here is what I expect once the data lands in Excel: • Each original table in its own worksheet, clearly labeled. • Column headings repeated and styled for easy filtering. • Conditional formatting that quickly spots outliers and blank cells. • Basic summary formulas (totals, averages) at the bottom of each numeric column. • Consistent number formats (currency, percentages, dates) matching what appears in the PDFs. Accuracy is critical—I will spot-check random rows against the source files—so please use w...

I have a 50-page PDF that contains plain text only. I need every bit of that text transferred into a single-column Excel sheet. Each new logical section in the source should begin on a new row, and the first row for every section must use bold formatting so the headers stand out at a glance. Accuracy is critical; the Excel file has to mirror the PDF’s wording character-for-character—no omissions, no added spaces, and no spelling changes. I will spot-check for consistency before signing off. Deliverable: one .xlsx file completed to the above standard and ready for immediate use.

I have several Excel files that need to be copied, field-by-field, into a new sheet exactly as shown—no reformatting or interpretation required, just clean, accurate copy-pasting. The work is straightforward but must be done with absolute attention to detail so totals, dates, and text stay intact. You’ll receive: • A master Excel workbook with all source tabs clearly labeled • A destination template that shows where each value belongs Deliverables: • One completed destination file per source sheet • A quick spot-check report noting any blanks or discrepancies you find Turnaround is flexible but I would like steady progress updates so I can verify batches as you go. When you bid, please include a brief note on your data-entry experience—speed, accu...

I have a 50-page PDF that contains plain text only. I need every bit of that text transferred into a single-column Excel sheet. Each new logical section in the source should begin on a new row, and the first row for every section must use bold formatting so the headers stand out at a glance. Accuracy is critical; the Excel file has to mirror the PDF’s wording character-for-character—no omissions, no added spaces, and no spelling changes. I will spot-check for consistency before signing off. Deliverable: one .xlsx file completed to the above standard and ready for immediate use.

I need someone to automate tasks in a Microsoft Excel spreadsheet that handles financial data. Key Tasks: - Automate data entry, analysis, or report generation (to be specified) - Ensure accuracy and efficiency Ideal Skills: - Proficiency in Excel, including VBA and macros - Experience with financial data - Attention to detail Please provide examples of similar work done.

I need an Excel expert to teach me and prepare some project planning spreadsheets. Key Tasks: - Data entry and formatting - Creating formulas and functions - Generating reports and charts Ideal Skills & Experience: - Proficiency in Excel - Experience with project planning spreadsheets - Ability to teach effectively Looking for someone who can start ASAP.

I need an Excel spreadsheet to automate the payment process for approximately 30 teachers in accordance with NC State's legislative yearly pay increase. Requirements: - Automatic pay calculations based on legislative rules - Individual teacher profiles, including personal details Ideal skills and experience: - Proficiency in Excel, especially with formulas and automation - Experience in creating professional, user-friendly spreadsheets - Attention to detail to ensure accuracy in pay calculations I have all necessary information ready for integration.