Vba excel csv addроботи

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно реалізувати автоматичну вигрузку csv файла з фтп в БД сайта. На сайті повинно бути поле вводу номера телефона (для перевірки кількості бонусів на сайті) після вводу, людині повинна прийти смс з кодом підствердження, після вводу відкривається інформація про клієнта, а саме ПІБ, номер телефону, номер бонусної картки та кількість накоплених бонусів

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Потрібно розробити імпорт інформацію з csv файлу та створити під неї сторінку телепередачі для сайту Детальне ТЗ в доці Приклад файлу імпорту прикріплений, для імпорту буде такий же, але в форматі csv

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

I'm looking for a skilled data parser who can extract product information from a specified website and organize it into an Excel spreadsheet. The data that needs to be extracted includes product descriptions. Ideal candidates for this project should: - Have experience with web scraping and data parsing - Be proficient in Excel - Have an eye for detail to ensure all data is correctly captured and organized.

...analytical skills and the ability to interpret quantitative and qualitative data. •Knowledge in validating information sources and critically analyzing data. •High level of English proficiency (C1 or higher) with advanced writing and editing skills in English. •Experience working with business intelligence reports, impact metrics, or financial analysis (preferred). •Familiarity with data analysis tools (Excel, Power BI, Tableau, etc.) is a plus. •Attention to detail and ability to manage multiple reports simultaneously. Key competencies: •Critical thinking and ability to detect inconsistencies. •Accuracy and attention to detail. •Ability to synthesize and communicate clearly. •Autonomy and proactivity in problem-solving. •Adaptab...

I need my Excel worksheet polished for print. The project involves enhancing the current layout of the worksheet, specifically to optimize it for printing. Key Requirements: - Adjusting the page layout and margins to ensure the worksheet is print-friendly. - Creating a green color scheme that is suitable for printing. Ideal candidate should have: - Proficient Excel skills especially in layout enhancement. - Experience in creating print-friendly documents.

I'm looking for a detailed Excel spreadsheet that covers the top 20 social media accounts for every sports team across the NBA, AFL (Australian rules football), NFL, MLB, IPL and international cricket. The accounts should span Twitter, Instagram, TikTok, and news outlets. Specific Requirements: - Top 20 Twitter accounts - Top 20 Instagram accounts - Top 20 TikTok accounts - Top 20 news outlet accounts - top 20 journalists covering the team - top 20 player accounts Each entry should include: - Account name - Profile link - Number of followers - Engagement metrics - Average post frequency: The average number of posts per day or week. Ideal Skills: - Proficiency in Excel - Familiarity with social media platforms - Ability to gather and analyze engagement metrics - ...

...growing team. Professional development and growth opportunities. To Apply: When applying for this role please include reference ATCMAX250127B when you provide an overview of top 4 reasons you feel you're suitable for this North American role. All applicants must past up to 2 levels of practical assessments to be considered for this which includes an Excel assessment. If you're not highly proficient in analyzing large amounts of data in Excel or equivalent, please don't apply....

...Example. $1234 in gross sales with a net of $565 would equal a GPM of 46 percent. 565/1234=.457 or 46 percent. ((1234x46 percent = 567.64)) Contractor will be required to connect and work remotely via teamviewer or anydesk. Please no exceptions. We are attaching a couple of examples of old pivot tables that need to be created. This contract is for about two hours of work for an experienced excel contractor. The above list is a general idea of the contract. It will contains errors and omissions. Its only provided to give an idea of what will need to be completed. Other variables may exist. Contractor will need to connect via phone and remote to work through the issues until the spreadsheet is fully built. You will be on the phone during the connection. US contractors prefe...

I'm looking for a video editor who can: 1. Turn my video attached into the same layout as the examples below 2. By adding relevant b-roll to the top half of the video 3. and add subtitled in the middle of it ***Please watch the examples and mimic the style of these videos: ***PLEASE include the word "panda" at the top of your submission so I know that you actually read this job description *If you are the lucky winner, my plan is to hire you to edit me 20 videos like this a month at ~$20 per video. Thank you :) The sample file is here since it was too big to attach (and no all the videos you edit for me in the future will not have the watermark haha): https://drive

...archivo pdf de buena calidad con 10 - 14 que no todas las hojas tienen tablas, el archivo que este en una carpeta llamada pdf y se tiene que extraer solo las tablas y pasarlas a otra carpeta llamada procesadas a un archivo Excel con el nombre de la primera hoja. Disponibilidad inmediata del Freelancer para ponernos de acuerdo en detalles. Si no hay comunicación por más de 8 horas o tarda demasiado en aceptar el trabajo se cancelará y publicará el proyecto de nuevo. 1.- Scripts en Python pdf a excel 2.- pdf en la carpeta llamada pdf 3.- extraer las tablas y hacer un archivo Excel con nombre de la primera hoja del pdf en la carpeta procesadas. 4.- cuadro de salida en Looker, power bi o tablear. Plazo de entrega 1 día máximo 1...

I urgently need a Data Entry and Payroll Clerk to work from home for my company, Luxoft. This posit...Luxoft. This position offers a competitive pay of $25 per hour and a variety of benefits including 401K, Medical, Vision Plans, and Life Insurance. The job comes with a flexible schedule, and you can work from anywhere of your choice. Key Responsibilities: - Entering data into spreadsheets - Processing payroll transactions - Maintaining employee records Necessary Tools: - Proficiency in Microsoft Excel - Experience with QuickBooks - Familiarity with ADP Workforce Now Essential Skills: - Attention to detail - Good communication skills Don't worry if you don't have prior experience, as we provide comprehensive training! Bonuses are available, and you will be paid weekly...

WORKS TO DO: - Add some functions to woocommerce "Orders" system = * on the orders list we see the "due date", if it is near current date, add red background; * we need that some Vendors can manage certain Brands (already added). When we edit the Vendor (wordpress user with user role Vendor) we must be able to assign Brands to it; * on the order edit, add the vendor name, next to the product name, on the order .PDF invoice generated, and products mut show total + taxes; * add extra fields to wordpress users, for example DNI, SKU, etc. and it must be visible on order edit; Thats is! Total budget is US$45,00.- dollars + Bonus (in 2 milestones). Since it is just some fixes. Please do not bid more than that amount. A Plu...

...allows users to extract lead data (emails, phone numbers, job titles, LinkedIn profiles, etc.) from websites and social media platforms (e.g., LinkedIn, Gmail, etc.), similar to Apollo, Skrapp, and Lusha. Integrate the extension with for easy export and management of leads. Build an intuitive and user-friendly interface that lets users view, filter, and export their leads (CSV, Google Sheets, etc.). Add features for email validation, contact enrichment, and automatic syncing with accounts. Ensure the extension works efficiently and is optimized for fast performance, without consuming too many system resources. Adhere to data privacy regulations (GDPR, CCPA, etc.) in terms of how data is scraped and stored. Perform cross-browser compatibility testing and debugging. Requir...

Troubleshoot excel xlookup formula

...store the data in a manageable format. Key Responsibilities: Develop a Chrome extension that integrates seamlessly with major websites to scrape user contact information (email, phone, LinkedIn profile, etc.). Implement advanced search and filtering capabilities to refine data. Ensure data privacy and compliance with relevant laws (GDPR, CCPA, etc.). Build features for users to export data to CSV, Google Sheets, etc. Implement a user-friendly interface and dashboard. Perform extensive testing and debugging to ensure smooth performance. Requirements: Proven experience in developing Chrome Extensions (provide examples). Strong knowledge of JavaScript, HTML, CSS, and related web technologies. Familiarity with web scraping techniques and APIs. Ability to work with third-party serv...

...into an Excel spreadsheet. You'll be dealing with: - Data Fields: Name, Address, Email Your tasks will include: - Data Entry: Inputting the specified data fields into Microsoft Excel - Data Cleaning: Ensuring the data is accurate and free from errors - Data Validation: Adhering to unique data validation rules as instructed Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience in data entry and data cleaning - Attention to detail for data accuracy - Ability to meet deadlines - Familiarity with data validation rules Please be prepared to adhere to: - Expected Format: Data must be entered in Excel - Accuracy Standards: High level of accuracy is required - Deadlines: Timely completion of the project - Specific Software: ...

I'm seeking a seasoned developer to create a robust web-based CRM system for my business. The system is intended to streamline the management of sales, orders, expenses, and payments, both internally and with external API servers. Key Features: - Automation of data import from CSV/XLSX files and APIs with built-in data validation - Accurate order matching - Comprehensive tracking of expenses, employee salaries, and overall profitability - Fund reconciliation capability with Binance and other payment sources - Support for multi-currency transactions - Role-based access for different user levels: Admins, Managers, and Employees - Generation of detailed financial and operational reports Ideal Candidate: The perfect candidate for this project is an expert in CRM development with ...

I'm looking for someone to send my cover letter and resume to a list of recruiters. Details: - The email addresses are in an Excel spreadsheet. - I want the emails to be personalized with each recruiter's name, but not tailored to their specialization. - I would like email to come from a gmail address Ideal skills for this project: - Proficiency in Excel - Excellent written communication skills - Ability to personalize mass emails - Familiarity with email services such as Gmail or Outlook

...Work alongside the best, elevate your skills, and accomplish things you never thought possible. * Shape the Future: Directly contribute to innovations that will redefine how things are done in the commercial real estate tech industry. If you’re not confident you’re in the top 5%, please don’t apply. We’re looking for exceptional developers who thrive on high-stakes challenges and are ready to excel in a fast-paced, dynamic environment. About Us ======== We’re a rapidly growing startup in the commercial real estate tech space, and we're looking for a Laravel Developer who’s not just skilled – but hungry to take on challenges, move fast, and make an impact. We're a small but mighty team, and we need someone who thrives in a hig...

Un ficher Excel contenant 3601 lignes vous sera transmis, incluant les informations suivantes : - SIREN - NOM DE LA SOCIETE Le résultat attendu de votre intervention est la collecte de données des informations suivantes: - L'activité principale/réelle de la société est-elle la vente de parfum ? (croisement de donnée entre site web, , facebook...). Si oui, alors le résultat doit inclure : - Email de la société (ou site web si mail indisponible) - Téléphone Délai : Le plus rapidement possible

I'm in need of a freelancer who can assist with data entry from PDF documents. The job entails copy-pasting information from these documents into Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with data entry - Attention to detail - Ability to handle PDF documents - Good copy-pasting skills

I'm looking for a skilled professional who can convert my existing Excel/Numbers order form into an online order entry system. This project will involve creating both a basic version and a database-driven version of the order form. Key Requirements: - The online order form should be integrated with a custom Order Entry System. - It would need to replicate the tabs on the excel and the basic formulas - It should have the capacity to store customer data, specifically contact information and details pertaining to my business clients and schools. Ideal Skills and Experience: - Proficiency in Excel and Numbers - Experience in developing online order systems - Knowledge of database management - Understanding of customer data storage solutions Please no...

I'm looking for someone to extract stock symbols (tickers) for companies listed on the NSE and BSE, and enter them into an Excel spreadsheet. I need this done just once, so there's no need for ongoing updates. Skills and experience ideal for this job include: - Proficiency in data entry and Excel - Familiarity with stock markets, particularly NSE and BSE - Ability to accurately extract and input data.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I'm looking for a detail-oriented professional to manually add 150 invoices to my QuickBooks within a 48-hour timeframe. All invoices are in digital format, primarily a mix of PDF and Excel, with some being scanned copies. Key Responsibilities: - Accurately inputting each detail from the invoices into QuickBooks - Associating each invoice with the corresponding customer name - Attaching the invoice to its respective entry in QuickBooks Necessary Skills: - Proficient in QuickBooks - Strong attention to detail - Excellent data entry skills - Able to work under tight deadlines Ideal Candidate: - Has experience with manual data entry from digital invoices - Can ensure complete accuracy and integrity of data input - Is dedicated to meeting the 48-hour deadline invoices w...

I'm looking for a video editor who can: 1. Turn my video attached into the same layout as the examples below 2. By adding relevant b-roll to the top half of the video 3. and add subtitled in the middle of it ***Please watch the examples and mimic the style of these videos: *If you are the lucky winner, my plan is to hire you to edit me 20 videos like this a month at $25 per video. Thank you :) The file to download is here since it was too big to attach (and no all the videos you edit for me in the future will not have the watermark haha):

I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.

I have a 10 page annual report that i need populating from excel. The task is very simple max 1 hr. I will send you a word document that requires you to put in 2024 numbers from excel. and check the notes are corresponding to Balance Sheet, P&L and etc. general check for casting and cross casting. These accounts are not audited and they are fairly simple.

In this project we will add new features in our website and we will shift to chatGPT instead of using Divine API

I need assistance in linking my website () to a MySQL database on Hostinger. This involves connecting website buttons and data capture from user interactions. I aim to integrate 1 to 2...data capture from user interactions. I aim to integrate 1 to 2 of my websites into this system. Key Data Points to Capture: - User contact details (Name, email and type of contact) - Paypal Donations - Other Forms of Donation - Petitions Additionally, I require a simple method for data export, primarily as an Excel file. Ideal Skills for this Job: - Proficiency in MySQL - Experience with Hostinger - Web development skills - Ability to set up data capture from website interactions - Excel data manipulation skills Please include examples of similar projects you've worked on in your bid...

...considerations and best practices for a robust FinTech application. --- ## 1. Overview ### Widget Objective A **Stock Sentiment Predictor** Widget that: 1. **Scrapes financial news articles** for a given stock ticker and date range. 2. **Applies GPT-4 (or other large language models) and classical sentiment analysis** to generate a quantitative sentiment score (ranging from 1–10). 3. **Outputs**: - A **CSV** with per-article sentiment scores and metadata (e.g., publication date, headline, source). - A **graph** (PNG/SVG) visualizing the sentiment trend over the selected time range. ### Intended Users - **Retail Investors**: Quick insight into market sentiment. - **Financial Analysts**: Additional layer of data-driven signals for research. --- ## 2. Interface Req...

I need help with processing and analyzing datasets from a 9-axis IMU sensor placed on the back of a runner. The data is stored in CSV files. Key Requirements: - Python programming skills to identify and calculate features like vertical oscillation, stride length, ground contact time, and running symmetry from the IMU data. - Ability to create visualizations in the form of line charts to represent the calculated features. Ideal candidates should have a background in data analysis, experience with Python and CSV files, and the ability to create clear and informative visualizations.

I'm looking for an Excel expert to create a sheet for data analysis, specifically for financial data (MahaRERA CA Form 03). The sheet should leverage pivot tables to help dissect and interpret the data effectively. The data and format will be provided. Ideal skills and experiences for this job include: - Advanced knowledge of Excel, particularly with pivot tables - Experience in financial data analysis - Ability to create user-friendly, functional Excel sheets.

¡Hola! Me gustaría contratar a un desarrollador que hable español de manera fluida para crear una hoja de cálculo (preferiblemente en Google Sheets, aunque podría ser en Excel) que gestione el flujo de caja diario multimoneda para la oficina de Inmobiliaria. El objetivo principal es: - Controlar la entrada y la salida de dinero diariamente. - Saber exactamente con cuánto dinero cierra la caja al finalizar el día. - Permitir el registro de movimientos en cuatro monedas: Dólares (USD), Pesos Colombianos (COP), Euros (EUR) y Bolívares Venezolanos (VES). Requisitos específicos: - Diseño intuitivo y fácil de utilizar para ingresar datos diariamente. - Tablas o secciones que permitan registrar las tr...

I have a list of 3000 emails in a CSV file. I need someone to validate these email addresses, ensuring they are correct and usable. Key Responsibilities: - Check the email addresses for validity - Segment the email list based on specific criteria after validation Ideal Skills: - Proficiency in handling CSV files - Experience with email validation - Skills in data segmentation - Attention to detail - Ability to work within a budget of $50 Please provide your proposal if you fit the criteria and can deliver quality work within the budget.

1-Dashboard Template Integration, responsive 2-Grid Implementation. With all functions existents on My actual system. 3-UI/UX Enhancements 4-Backend and frontend (YII2) 5- rest API. 6-Testing & Bug Fixes 7-Documentation. GRID functions. Add new data Update data Batch update the selecteds records. Batch update the data filtered. Delete the selecteds records Delete the all data filtered. Filters to all collumns Export to CSV and PDF Form example to field: string number date time combo box relation module checkbox radio editor html Multi Select video actual system

the usual - thanks! 6-11 redone and the tables in excel. Thanks a tonne as always TP.

...individual who can gather contact details of all kids football and rugby teams, aged between 6 to 18, within a 30-mile radius of PE72AR. The details should be compiled in an Excel format. Key Requirements: - Sources: Contact details should be sourced from official club websites, social media pages, local school websites and general internet searches. - Teams: The search should encompass both football and rugby teams. - Contact Details: The primary focus should be on collecting email addresses, with contact names also being a bonus. Ideal Skills: - Proficient in data gathering and internet research. - Familiarity with Excel and data entry. - Understanding of youth sports teams, particularly football and rugby. - Ability to work independently and deliver quality results in...

As we discussed please give your best to do it in 1 month. Thank you very much so far.

...Channel Name Subscriber Count Country/Region Channel Language Owner Name (if available) Contact Email (from YouTube 'About' section or other sources) Social Media Links (if available) ? Preferred Tools & Methods: YouTube 'About' section for emails Noxinfluencer, Social Blade, or similar tools LinkedIn, Twitter, or Instagram for direct contacts ? Deliverables: A well-organized Google Sheet or Excel file with verified information. ? Ideal Candidate: ✅ Experience in web research & data entry ✅ Familiar with YouTube influencer search tools ✅ Ability to verify and validate contact details ✅ Attention to detail to avoid fake or inactive accounts ? How to Apply: Send a brief proposal explaining your experience in similar projects, your approach, and how ma...

...be provided) The weekly responsibilities will involve 1 hour of research and processing of 5-10 funding programmes: - Eligibility Criteria - Details of the funding calls (GPT generated) - Application Deadlines - Fund Amount - Generate keywords/tags (GPT generated) - Generate a 1-page summary per funding call (using my template - a Word document will be provided) - Input the details into an Excel file Ideal candidates should possess strong research skills, familiarity with various funding sources, and experience in data organisation. A keen attention to detail is crucial for accurately capturing the specifics of each funding opportunity. Quote only the funding amount you are happy to be paid for doing the work for 1 week. Each week, we will have a new milestone with the sam...

Modification of a Financial Model in an Excel Spreadsheet We have an existing financial model in an Excel spreadsheet and are looking for someone to modify various parameters and adjust the model as needed to meet our current requirements.

Hey, PLEASE READ CAREFULLY I'm looking for someone who can build a full automation to create hundreds of micro blog and add one article on each blog. Each article must contain one link to my website. Someone on a freelancer platform did the same for my website, he was able to create 500 blogs with 500 articles with one link on each article. I need the same for my websites. If you are able to do that please contact me, do not bid if you can't do it. Thank you

I need a comprehensive Power BI dashboard that connects to my Excel database. The dashboard should visualize various metrics such as open and close actions, incidents (including dates, locations, types, etc.), inspections, and more. Key Requirements: - Strong expertise in Power BI - Proficiency in Excel - Experience with data visualization - Ability to create charts, graphs, tables, and matrices This project aims to provide a clear and insightful visual representation of my data, helping to uncover trends and patterns. Please provide relevant examples of your previous work with Power BI.