Excel vba manipulate textроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Перекласти 3 сторінки тексту художнього стилю з англійської на українську мову. Необхідний рівень володіння англійською мовою-C1-C2. Translating the text to Ukrainian from original(English). A level of C1 or C2 is required.
I wrote some code that manipulates a specific image file. It’s functional- it can manipulate 1 pixel row of the image at a time , but now I want to expand the code’s functionality and am running into issues because I’m a novice coder. Realistically, I need you to put a single loop inside my code without breaking the existing functionality. I will provide code and the image to be manipulated. Ideal Skills: - Extensive experience with Matlab - Strong understanding of coding logic - Proficient in implementing 'for loops' Experience: - Prior experience with Matlab coding projects - Proven track record of successful loop implementation - Able to work with pre-existing code
I'm in need of a skilled Excel professional to help me create a new VLOOKUP formula. The data I'm working with is mixed - including both text and numerical data. The VLOOKUP will need to pull data from different worksheets, so experience working with multi-sheet Excel files is crucial. Ideal Skills: - Proficient in Excel, specifically with VLOOKUP. - Experience handling mixed data types. - Familiarity with navigating and pulling data from different worksheets.
I'm seeking a proficient Excel expert to create a Cost of Food Tracking sheet for me. This sheet will enable me to log all my food purchases against their corresponding events or meals. Furthermore, I need to be able to input the sales dollars for these events, which will allow the sheet to automatically calculate the food costs associated with each individual event. Ideal Skills and Experience: - Proficient in Excel with excellent data handling skills - Previous experience in creating tracking or accounting sheets - Understanding of food cost calculation in catering or restaurant context would be a plus - Ability to deliver a user-friendly and efficient sheet Please note, I do not require any specific templates or layouts. You have the creative freedom to design a sh...
Job Title: Excel Quote Sheet Creation for Residential Remodel Projects Job Description: We are looking to hire a freelancer to create a comprehensive yet simple Excel quote sheet template for residential remodel projects. The quote sheet will need to capture the key components of a residential remodeling project, including labor costs, materials, project timeline, and more. The goal is to have a clean, efficient, and professional-looking template that we can use for all our remodeling projects. It should align with our company's branding, and include all necessary formulas for calculations. Key Responsibilities: Create an Excel Quote Sheet Template: Design a clear and easy-to-use Excel sheet with formulas that automatically calculate costs. The sheet must...
I'm looking for an Excel expert who can create a mail merge template for me. Here's the breakdown of what I need: - The data for the mail merge will include: company name, address, phone, people, their title, email, and phone number. - The output documents should be letters - I will be generating these letters through Gmail Ideal Skills: You should have a strong command of Excel, experience with mail merges, and familiarity with Gmail.
I'm in need of a Python script that will scrape TikTok for videos related to the "Romanian 2024 November elections and Calin Georgescu". The data should be compiled into an Excel spreadsheet and the script needs to run daily. Key Scraped Data: - Video URL - Username - Views - Likes - Comments Ideal Skills: - Proficient in Python - Basic understanding of web scraping - Familiarity with the TikTokApi of Python - Excellent communication for updates and discussions Please ensure the code is error-free and runs smoothly. Looking forward to your bids.
I'm seeking a classic style logo, purely text-based, to be designed in a serif font. Key requirements: - Expertise in classic logo design - Proficient in serif typography - Experience in creating purely text-based logos
I'm in need of a freelancer proficient in Excel. My project involves primarily data entry and the organization of text data. The data needs to be sorted meticulously by specific categories. Ideal candidate should have: - Excellent skills in Excel, particularly in data entry and organization. - Ability to understand and sort data by various categories. - Attention to detail to ensure data is accurately entered and organized.
I'm seeking a detail-oriented freelancer to assist with manually entering information from my scanned PDF receipts into an Excel spreadsheet. Key Information to Extract: - Date - Amount - Receipt Number - Received From - Payment for - Student Name - Grade Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry - Ability to follow instructions accurately. 496 Receipts to enter - see example of Receipt and Spreadsheets in files tab/section.
Un formato mucho mas optimizado de la actual plantilla (adjunta) para la confección de la estadística anual de esta unidad. Necesario hablar Español para poder entendernos.
Preciso de alguém que me ajude a desenvolver uma planilha no Excel e que me ensine um pouco também
Sincronización Bidireccional de Datos en Excel mediante Lista de SharePoint y Archivo Maestro Descripción General: Se busca desarrollar una solución que permita la sincronización bidireccional de datos entre dos o mas archivos de Excel independientes (por ejemplo, y ) y un archivo maestro consolidado, utilizando una lista de SharePoint como fuente central de datos. El objetivo es que cualquier modificación en uno de los archivos se refleje en la fuente central y, a su vez, se actualice en todos los archivos conectados, permitiendo la edición colaborativa en tiempo real o con actualizaciones muy frecuentes. Objetivos Específicos: Centralizar los Datos: Utilizar una lista de SharePoint para almacenar la informaci&oacu...
...freelancer capable of creating a comprehensive Excel spreadsheet, alongside a detailed Word report and PowerPoint presentation for a capstone project centered on the merger of Company A and Company B. - Excel Sheet: This must encompass a complete dataset spanning five years for both companies, inclusive of historical data, future projections and all M&A related calculations. - Word Report: This should cover all relevant information pertaining to the M&A, detailing the financial status before and after the merger, the financial implications and outcomes. - PowerPoint Presentation: This must effectively summarize the key findings and insights from the Excel sheet and Word report. The ideal candidate will have strong expertise in financial analysis, Excel...
I'm in need of a skilled graphic designer who can provide me with a vector file of my logo in 3 different color variations, specifically using my brand colors. The vector file needs to be in SVG, EPS and AI formats. Key Requirements: - Proficiency in graphic design software - Ability to create and manipulate vector files - Understanding of color theory and brand representation - Timely delivery of the project
I'm looking for a freelancer who can convert my Excel file into a PDF. The file primarily contains text and numbers. The ideal candidate for this project should have a strong proficiency in Excel and PDF software. Attention to detail is crucial as the conversion should preserve the integrity of the data.
I am currently working on an assignment focused on the German Tax system. I need someone who has expertise in German Tax system and can help in preparing excel formulas for Steuerklasse 1 to Steuerklasse 6 in excel. Ideal freelancers for this project should have: - Expertise in tax law, specifically the German system - Experience in tax calculation methodologies. I already have an excel that has basic details but the calculation is wrong. I would be happy to share existing excel file.
I need assistance in creating a series of documents in Google Docs from provided Google Templates. This includes 72 weeks of Managers' Meetings and 12 days of Governing Body Meeting Minutes. All necessary data will be provided in Excel spreadsheets, and the formatting will be supplied by me. Ideal Candidate: - Proficient with administrative tasks - Experienced in Google Docs - Able to follow specific formatting instructions This task is expected to take approximately 3-5 hours. ChatGPT can be utilized if needed.
I am seeking a professional and structured pay slip template in Excel with a modern design. The template should comprehensively cover various aspects of payroll, including: - Employee Details: Name, ID, job title, SIN - Pay Period Details: Start/End dates, pay date, YTD earnings - Work Hours: Regular, overtime, vacation, sick leave, holidays - Deductions & Taxes: Federal/Provincial tax, CPP -5.85%, EL -1.58% - Benefits: Health insurance, life insurance, RRSP - .NET Pay Calculation: Earnings minus deductions - Employer & Bank Details: Company name, payment method, direct deposit The template needs to use the 2024 tax brackets and ensure accurate calculations. The layout should be clean, professional, and well-structured, reflecting a modern style. In terms of design speci...
I have an Excel database containing 814 names and addresses of clients, and I require accurate, current email addresses for this list. This project will facilitate my client communication and potentially lead to a long-term collaboration, as I have many similar tasks in the pipeline. Key Responsibilities: - Find and provide accurate email addresses for the given names and addresses. - Ensure the email addresses are current and valid. Ideal Skills and Experience: - Proficiency in data mining and research. - Experience in finding email addresses for specific individuals or businesses. - Familiarity with Excel and data processing. - Excellent communication skills, as some individuals on the list are previous clients. Your expertise and capability to deliver accurate results ...
I require assistance in automating the process of populating Excel files (.csv) with data extracted from various e-commerce sites. The ideal freelancer will be: - Proficient in creating and manipulating .csv files in Excel - Experienced in web scraping, particularly from e-commerce sites - Able to programmatically collect product details and pricing information - Skilled in identifying and capturing specific product details such as names, descriptions, specifications and images - Willing to remote connect to my PC to observe the manual data entry process and build an automation tool based on it This project aims to speed up and automate the manual process of data entry. Please ensure you have the skills and experience necessary for this task.
We have requirement text to .amr convertor in C#,
We have reuirement to develop text to .amr convertor in C#
We have requiremtn of Text to .amr convert in C# or wave to .amr convertor
We have require Text to audio converter in C# ( audio in any language)
I'm seeking a professional who can assist me with cleaning up some screenshots. The task involves removing scribbles and strikethroughs from screenshots and extracting the original text underneath without using the surrounded pixels. Key Requirements: - Proficient in image editing and text extraction - Able to maintain exact reproduction of the text, including font and formatting - Flexible to handle text in various colors The extracted text will primarily be used for image repair, so precision is key.
I'm in need of a meticulous professional to sift through certain emails and enter mixed data (text and numbers) into an Excel spreadsheet. Key Tasks: - Data extraction from specified emails based on given criteria - Entering mixed data into Excel accurately Ideal Skills and Experience: - Proficiency in Excel - Excellent attention to detail - Experience in data entry and email management - Ability to follow specific criteria Looking forward to your bids!
I'm looking for a skilled ML Engineer to help me with a predictive modeling project using customer text data. Key Requirements: - Expertise in predictive modeling with a focus on text data - Proficient in data analysis and visualization - Experience working with customer reviews - Strong skills in natural language processing - Ability to derive insights from customer data - Capable of developing, testing, and improving models Your role will involve working with customer reviews to develop predictive models that can provide valuable insights and forecasts. The project requires a blend of machine learning expertise, data handling skills, and experience with text data. You should be comfortable visualizing data and results, as well as iterating on models to improv...
...tarjetas de crédito. Historial de pagos: Registrar todos los pagos recibidos, asociándolos con los tickets de servicio. 10. Reportes de Desempeño: Estadísticas de trabajo: Mostrar métricas sobre el número de reparaciones completadas, ingresos generados, tiempos promedio de reparación, satisfacción del cliente, etc. Exportación de reportes: Permitir exportar los reportes de actividad en formato PDF o Excel. 11. Funcionalidad Multicanal: Chat en línea: Para responder preguntas rápidas y ofrecer soporte de manera instantánea. Correo electrónico integrado: Además de generar cotizaciones, la aplicación puede permitir enviar mensajes de seguimiento o responder dudas directamente des...
I'm in need of a detailed-oriented professional to help build an email list of the top 1-2 marketers from 500 regional U.S. banks. This will include gathering their names...marketers from 500 regional U.S. banks. This will include gathering their names, titles, and emails. Tasks: - Identify and collect details of individuals holding the titles of Chief Marketing Officer, Marketing Director, and Marketing Manager at each bank. - Use ZoomInfo as the primary online research tool to ensure accurate and efficient data gathering. - Deliver the final list in a Google Sheets, Excel or CSV format. I’m looking for someone with experience in data research, who is proficient with online search tools, and has a keen attention to detail. Your work will be crucial for our upcoming ou...
...than 500 open positions to fill, our teams are expanding rapidly, and the rewards are exceptional. As a key player in our Talent Acquisition team, you’ll be responsible for identifying, establishing, and managing a variety of sourcing channels to attract high-caliber talent. If you’re passionate about recruitment, tech-savvy, and results-driven, this role is a perfect match for you. Plus, if you excel in this role, you’ll have the opportunity to lead teams and advance quickly within our organization. Duties: Identify and evaluate relevant candidate sourcing channels to complement our current tech stack. Manage and optimize accounts for sourcing channels. Post job openings and proactively source candidates via multiple channels. Continuously suggest improvemen...
Merge two excel workbooks with common field
Urgent task need to be done in next hour !
...confident that I am the ideal candidate for this project. My skills, experience, creativity, and technical knowledge make me the perfect fit to contribute effectively to the success of your web story company. Understanding of Web Stories and Their Impact Web stories are short, visually engaging, mobile-friendly pieces of content that captivate users. They combine images, videos, animations, and text to create a seamless narrative experience. Understanding user engagement metrics, storytelling techniques, and digital marketing trends is crucial for the success of web stories. I have an in-depth understanding of: The importance of bite-sized, immersive content for today's digital audience. User experience (UX) and user interface (UI) principles that enhance story accessibi...
I'm looking for a freelancer with expertise in Excel Dashboard to create a collaborative spreadsheet for me. Key Requirements: - The sheet will need to be user-friendly as it will be accessed by multiple users. - Experience in creating interactive and intuitive spreadsheets is a plus. - While I haven't defined its specific functions yet, a background in data analysis, inventory management, or tracking and reporting could be beneficial. - Ability to incorporate automation using scripts or macros would be a significant advantage, though for now, manual updates are fine. Please provide examples of similar projects you have completed in your proposal.
...changes in the Bill of Materials tab/page, along with an export and import data feature that supports Excel and CSV file formats. There are also some issues with the backend-frontend connection that need to be resolved. Scope of Work: -Enhancing Application Functionality: -Implement new features based on project requirements. Modifying SQLite Database Design: -Alter existing database schema to support the changes in the Bill of Materials tab/page. -Ensure data integrity and migration from the old schema to the new one. Implementing Data Import and Export Features: -Develop functionality to import data from Excel and CSV files with acceptable data points. -Enable export of data in both Excel and CSV formats. -Validate imported data to prevent inconsistencies. Fix...
I need someone skilled in data entry to help me transfer text data from online SQL databases into a different format. Ideal Skills: - Proficient in SQL and data handling - Excellent attention to detail - Fast and accurate typing skills - Experience with data entry from online databases Please bid if you are capable and experienced in SQL database operations and data entry.
I need help with cleaning, analyzing, and visually representing mixed data in an Excel sheet. The data set contains both text and numerical data, all of which needs to be processed. Specific tasks include: - Text data: Removing duplicates, correcting typos, and standardizing formats - Numerical data: Handling missing values and removing outliers Ideal skills for this project include Excel proficiency, data analysis, and experience with graphical representations. The freelancer must have a keen eye for detail and able to identify and resolve data issues.
...manufacture electromagnetic flow meters and are not just resellers. Data should be recent and verified through official sources (company websites, directories, industry associations, etc.). Preferred Skills: Strong internet research skills Experience in market research or industrial product sourcing Ability to deliver well-structured data in Excel or Google Sheets Familiarity with the flow meter industry (preferred but not mandatory) Deliverables: A well-organized Excel or Google Sheet with all the required fields Minimum 1000 verified manufacturers (if feasible) Sources of information used Budget & Timeline: Budget: Open to fair proposals based on expertise and quality of data. Timeline: Deliverables required within 7-10 days. How to Apply: Interested freelancers shou...
I need a Python script for my Raspberry Pi that takes input from 4-7 latch type buttons. The script should record the time, date, and duration of each button press, and output an Excel-style file with this data. Key requirements: - The spreadsheet should display how long each button was pressed, rounded to 15-minute intervals in a weekly calendar format. - Another tab or table should show the time and date that the buttons started and stopped, functioning as a time clock for multiple jobs. - The script should include coded pull-up or down resistors to filter out noise from the buttons. - Optionally, the spreadsheet can be emailed at regular intervals or by command to a specified email address. I prefer the code to be simple yet reliable, with ample comments so I can understand and...
I need someone to enter data manually into an Excel.
I'm looking for someone to help me export my digital products from OpenCart to a trial website and also into an Excel sheet. Key Tasks: - Exporting digital products to a trial OpenCart website. - Recording specific data fields into an Excel sheet. Data Fields Required in Excel: - Product name and description with pictures - Product price and SKU - company Name with pictures Ideal Skills and Experience: - Proficiency in OpenCart is crucial. - Experience with Excel, particularly in managing product data. - Knowledge of digital products and e-commerce platforms is a plus.