Vba data extract vba jobs

I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data needs to get into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. I'm seeking a freelancer with experience in the Amazon Seller API to pull back data and metrics - all columns of data related to Sales, Orders, Products, Cu...

I require the assistance of a skilled professional in web data scraping from Website 1. Your primary task will be to extract contact details. Upon successful scraping, these data needs to be cleaned and formatted before being delivered in an Excel sheet. The ideal candidate for this job would have solid experience in data mining, data cleaning and Excel. Skills and Experience: - Data Scraping - Data Cleaning - Microsoft Excel proficiency

I am working on a scientific project involving the use of reinforcement learning in the automotive industry. To succeed, I need an expert in MATLAB script to assist me in model training. Key tasks include: - Use the provided output data from the vehicle to enhance the vehicle model. - Implement and shape the reinforcement learning model to meet project specifications. - Extract a final thesis and scientific paper upon successful implementation and testing. Ideal skills and experience: - Extensive experience with MATLAB using reinforcement learning. - Prior work in the automotive sector is preferred. - Strong understanding of scientific thesis writing. This is a high-level project, requiring excellent attention to detail and a strong commitment to quality and accuracy. If...

I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

i want who can start work immediately just simple scan the QR code and push to server using webservice, i need this to be by today itself. Looking for a skilled developer to create a mobile application compatible with both iOS and Android platforms. The key functionality needed is an Optical Character Recognition (OCR) feature that can effectively and accurately extract text from various image types. Ideal Candidate: - Proven experience developing cross-platform mobile applications - Prior experience with OCR technology is a must - Strong understanding of image processing - Ability to deliver high-quality, efficient code Requirements: - Build a mobile app for iOS and Android - Integrate accurate OCR technology - Develop a feature for text extraction from images - Ensure seamless ...

I'm seeking a freelancer with proficiency in Python3 and OCR processes to assist with my forthcoming project. The objective is to establish an environment that can accurately extract printed text content from PDF documents. This extracted data should then be converted and provided in CSV format. The possible necessity of machine learning integration is anticipated, hence experience with such is advantageous. Key job requirements: - Python3 expertise for environment setup - Proficient in OCR for printed text extraction - Capability to export extracted data into CSV format - Familiarity with machine learning is a plus.

...to fetch a list of top traders for a specific coin/blockchain network (e.g., Base Blockchain). Analyze each trader's wallet address to extract their trading history, including the number of trades, coins traded, and profit/loss for each trade. Identify and track related wallets for each main wallet, enabling the calculation of aggregate earnings across multiple addresses associated with a single trader. Calculate the overall success rate and profitability of each trader based on their trading history. Provide a user-friendly interface to view and analyze the collected data, including visualizations and filtering options. Implement robust error handling and data validation mechanisms. Ensure the tool is scalable and can handle a large number of wallets and trans...

We are in need of a Python script to extract a specific type of data from a social platform. Only Indian Python Developer Required. Key Details: - Purpose: The primary purpose of this script is to extract numbers from the social media platform. - Complexity: The data to be scraped is relatively straightforward. It's all about extracting numbers and not complexly nested or paginated. - Source: The numbers are scattered across various parts of the social media platform. Ideal Skills and Experience: - Proficiency in Python: A strong background in Python scripting is essential. - Web Scraping: Experience in web scraping will be crucial for this project. - Social Media Data Extraction: Prior experience in extracting data from social media platfor...

I need a simple PHP script, using as few files as possible (preferably a single PHP file). The goal is to extract the following data from the google AD ad system: Campaign names and today's daily spend per campaign. In addition, which campaigns are running and which are paused. Finally, a simple buttons - for each campaigns: run a campaign, or pause a campaign. A test google api key is required because I can't give out my own. For the project I need a description how I can run the file and how I can replace the test api key with my real (own) key.

Detailed description of services provided: RF Test Analysis: We will begin with an in-depth analysis of the RF test results provided, to understand your antenna's current performance and identify areas for improvement to meet CE-RED and FCC certification requirements. Antenna Redesign: Following our analysis, it is clear that a revision of the antenna desig...design is required to reduce transmit power at the 7217.00 MHz frequency. We therefore propose to redesign the antenna by adjusting its dimensions to achieve the required transmit power levels. Antenna import: If you already have a simulation file, we can import it directly into HFSS to speed up the redesign process. Otherwise, please provide us with your PCB's Gerber file, from which we can extract the antenna and ...

I have an Excel file which have some scripting and data to connect to Oracle Database and download some log files and parse them into Excel Sheets. Also it parse the files looking for values and interpret those values in plain English ( read from a sheet) . i need to convert that Excel VBA to create a website using Microsoft IIS on my machine and be able to add more data to parse the files for more interpretations( reading the hex codes and display a new output with the hex code highlighted and next to it the English meaning of those codes.

Hello There is a complete program in PDF format with all the correct dates and percentages, while another program in XER format lacks both dates and percentages. Assistance is needed to extract the dates and percentages from the PDF and insert them into the XER program. Attached are the two XER files one name as "Greenview S" file and other as "Draft Programme Rev.03 (2)" All I want is from file name: (Greenview S file) u need to take the actual start and finish dates and percentages ... and then simply insert in the file name: (Draft Programme Rev.03 (2)file) both the files are attached

I need a web scraper to extract text from a provided list of URLs on a Google Sheet. - The URLs will be provided in a list. - The scraping should be done only once. Your tasks: - Scrape the text from the URLs. - Update the Google Sheet with three columns: URL, Title, and Text scraped. - If a URL doesn't contain any text or leads to an error page, please skip it and move on to the next URL. Key skills: - Experience in web scraping. - Proficiency in Google Sheets. - Attention to detail to handle exceptions as per the requirements.

I urgently require a web scraper built to scrape the exercise program layout from a specific fitness website. Your task will be to extract data pertaining to the personal training categories, subcategories, and filters. Specifically, the scraper should be: - Able to extract the training categories and subcategories - Efficient in scraping price filters - Functional and delivered by today The ideal freelancer for this project should have previous experience in creating a web scraper and a strong understanding of data extraction from complex website layouts. Prompt delivery is of the essence for this project.

I'm urgently needing a detailed analysis of an external bank website and one ...urgently needing a detailed analysis of an external bank website and one main competitor. Specifically, I need an in-depth look into: - Traffic sources - User behavior - SEO performance - Ads recommandations The main goals for this analysis are: - To pinpoint areas for improvement, - Strategies to drive up conversion rates - And enhance search engine rankings. - Extract data on a google sheet to create a Looker/Google data studio dashboard and present it. Timeliness is essential for this project. Ideal candidates should have a strong background in website analysis, understanding of SEO, and experience with SimilarWeb or equivalent tools. Your ability to deliver rapid, accurate...

I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should understand how to n...

I'm currently seeking a professional data scraper who can successfully extract specific content from an existing mobile app.

Please apply only if you agree with the terms outlined below. Hello, I am seeking a freelancer's assistance in extracting a list of agents from a property portal. I am looking for someone who can either create a script in PHP or Python for this task or manually extract the data, which comprises 6231 profiles, and deliver the results in an Excel file. I require a quick turnaround, ideally within a few hours, and my maximum budget for this project is $30. Thank you.

I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel

I'm looking for a skilled data engineer to help me with the OMOP ETL process. Your main responsibilities will be: - Extracting and transforming data: You'll be working with me to extract data from a data warehouse and transform it into the OMOP CDM. - Loading data into a database: After transforming the data, it will need to be loaded into a PostgreSQL database. Experience with ETL processes and PostgreSQL is critical. You should also be familiar with data validation checks, as we need basic data type and range checks applied during this project. You must have experience loading data into the OMOP CDM.

I think I'm on the right track other times to recognize the patterns of the text which are similar to the elements of a command I would have used regex and other but with the AI I can submit the command to it and it will be able to extract the elements. data that interests me will you be able to support me in this project access to an AI with APIs or use a local AI?

...are seeking a freelance developer to create a plugin similar to "webpilot" for OpenAI, enabling a virtual assistant to gather data from specified websites via URL. The assistant should be able to interpret simple commands to extract information and return it in JSON format. Project Objective: The first milestone will be to develop a prototype capable of connecting to a website, extracting specific information, and structuring it in JSON in response to a voice or textual command. Responsibilities: Develop an assistant based on the OpenAI API that can extract data from provided URLs. Ensure that the assistant can interpret precise commands to extract and structure data. Provide a simple interface for initiating requests and receiving r...

I am in need of a mobile application that enables scanning of various document types using the phone camera. The app should have the ability to extract text from the scanned documents via OCR technology, enhancing flexibility and functionality. Specific features desired: • Phone Camera Document Scanning: The app should facilitate the scanning of multiple document types—ranging from text documents and receipts to business cards. While the document type isn't specified, the app should be versatile enough to cater to different scenarios. • OCR (Optical Character Recognition) Technology: The ability to extract the text from the scanned document is essential for the project. This will make the information easily accessible, searchable, and usable. For thos...

Please Sign Up or Login to see details.

I am in immediate need of a freelancer skilled in VBA & .net for the development of a yet disclosed project. The ideal candidate must be proficient in all aspects of VBA and have the ability to deliver quickly given the urgency of this project. Key Requirements Include: - An in-depth understanding of VBA - Proven track record of successful projects - Ability to work under tight deadlines Completion of the project needs to be as soon as possible. If you have extensive VBA experience and can work in a fast-paced environment, I enthusiastically encourage you to bid on this project.

We are seeking to develop an MVP for a SaaS product that leverages AI technologies to transcribe, rephrase, recreate, and translate videos. This platform will enable users to upload videos, extract and edit transcriptions, rephrase content to target specific audiences, synchronize the original audio with new lip movements in the video, and convert audio and subtitles into other languages.

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentatio...

Need a fast PHP Scraper now, so the next 3 hours. I want to scrape all real estate from a homepage and add it to a mysql database. But there is a next button we have to press several times, to see all advertised appartements. Its called "Mehr anzeigen". When its pressed multiple times, all objects are shown. Extract every data, store to database. Check if appartement is still in database, if not, send me a email with the url. I want to identify new interested appartements. Cronjob should run every hour. I have a server with php and mysql for that. Homepage:

I'm seeking a dedicated person who knows data engineering and data analysis with special expertise in AWS services. Your primary responsibilities will include: - Data cleaning and preprocessing: Handling a variety of data structures, from unstructured to semi-structured and structured - Data modeling and warehousing: Proficiency in using AWS S3, Athena, Glue, and other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work wi...

I have a list of 639 companies. I have filters associated with the people I want to scrape. I want to scrape Linkedln or another platform (you suggest) to extract the function, company, email and phone number of the people in these companies. Contact me if you've already done this. This is an automatic French company. Please ensure you have past experience in similar projects and are able to deliver high-quality, cleaned data. Thank you.

I am seeking an investigative journalist with a knack for unraveling complex crime activities and creating engaging video documentaries. Utilizing your expertise, trace evidence, pinpoint witnesses, and narrate the course of your investigation in a compelling storyline. Key Responsibilities: - Conduct extensive interviews with key witnesses. - Locate and analyze relevant evidence. ...particularly in crime. - Proficiency in conducting ground interviews and collecting evidence. - Strong storytelling ability to make the documentary impactful. - Experience in creating video documentation/reporting is an added advantage. This project is an excellent opportunity for a seasoned investigative journalist, keen to dive deep into the world of crime and bring out an engaging visual ex...

I am seeking an investigative journalist with a knack for unraveling complex crime activities and creating engaging video documentaries. Utilizing your expertise, trace evidence, pinpoint witnesses, and narrate the course of your investigation in a compelling storyline. Key Responsibilities: - Conduct extensive interviews with key witnesses. - Locate and analyze relevant evidence. ...particularly in crime. - Proficiency in conducting ground interviews and collecting evidence. - Strong storytelling ability to make the documentary impactful. - Experience in creating video documentation/reporting is an added advantage. This project is an excellent opportunity for a seasoned investigative journalist, keen to dive deep into the world of crime and bring out an engaging visual ex...

...- It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if filled in, have print preset done as well. i will provide actual files and examples if y...

I'm in need of a specialist who can extract a large number of personal emails from gmx.de. The ideal candidate should be adept at navigating through a high volume of data to collect only personal emails, in the number of 5 million. Key Requirements: - Extraction of personal emails: The main and sole target is to collect personal emails from gmx.de. This is the core of the project and the freelancer must be skilled in executing this task. - Age, Location, Occupation Filtering: It is important that the emails extracted fall within the age range of 26-45. In addition to targeted age groups, filtering based on location and occupation should be considered to ensure the emails' relevance. The successful candidate should have: - Proficiency in Email Extraction Tools: Ex...

...and LLM, to extract meaningful information and create a dictionary. Key Responsibilities: - Develop a Python script with continuous input text processing capabilities - Implement advanced NLP techniques, especially GenAI and LLM, to process the text - Extract relevant information from social media posts and create a dictionary Ideal Skills and Experience: - Proficiency in Python, with a solid understanding of NLP libraries like NLTK, spaCy, and GenAI - Extensive experience in working with advanced NLP techniques such as GenAI and LLM - Previous projects involving text extraction and dictionary creation from social media posts - Strong problem-solving skills and the ability to work independently Please note that the primary purpose of this script is to understand and ...

I am looking for a skilled web scraping expert to help me extract specific data from a single publicly accessible website. The information I need includes product details, pricing data, and contact information. Ideal skills and experience for this project include: - Proficiency in web scraping techniques and tools - Previous experience with extracting product and pricing data - Familiarity with handling contact details in a structured format - Ability to work with publicly accessible websites and extract data efficiently If you have expertise in these areas and can help me with this project, please submit your bid. Thank you.

I need to collect text and video data from online sources. Ideal Skills: - Proficient in web scraping - Strong experience in handling both text and video data - Familiarity with a range of online sources Please note that you don't need to extract specific information from the text data at this stage. The main focus is on collecting both text and video data.

I need a talented professional who excels in secure web scraping, API integration, and data handling. I'm seeking to create a tool capable of downloading HTML content from a secure website, while ensuring stringent authentication and compliance protocols are maintained. Key Responsibilities: • Extract text content from HTML • Convert extracted HTML content into HTML format Ideal skills and experience: • Strong expertise in secure web scraping • Proven experience in API integration • Advanced knowledge of data handling • Proficiency in advanced authentication and compliance • Familiarity with HTML extraction for content analysis This project could be an exciting opportunity for those looking to apply their web scraping ski...

I have a blurry image taken with an iPhone that I need help with. I need someone to extract the text from the image, and hopefully identify the part name and brand of the item in the image. The extracted text should be delivered via email. I'm looking for a freelancer who has experience in image processing and text extraction. The ideal candidate should be skilled in enhancing the quality of images to extract text from blurry images. Experience in identifying parts or brands from images would be a bonus. Key skills and experience needed: - Image processing - Text extraction - Identifying parts/brands from images - Familiarity with iPhone image formats - Ability to deliver extracted text via email.

I'm seeking a knowledgeable individual who can teach beginner-level tutorials focusing on GPT-4 training and the implementation of AI techniques. Since I did not specify any programming languages o...proficient in teaching complex concepts in an easy-to-understand manner. We are looking create a knowledge base within our business that will help us embrace AI moving forwards and enable us to create GPT’s, mainly to extrapolate / merge / compare / reformat data from excel files. We would like to train 3 staff members with the knowledge of how to ultimately create GPT’s to take multiple workbooks of data, extract the relevant information, using GPT to identify and present the specific required information, then maybe reworking that data into a ...

1) VBA script that creates the excel file you want, 2) Python scipt that does the whole webscraping procedure and saves the data in the excel file named "" in the "Downloads" folder.

...in Website Traffic Data alerts if a product is available in the targeted location to those joining the bot according to the choice of the bot joiner. are 8 products, meaning whether they are available on the site or not. Key Attributes of the Ideal Freelancer: -The person I deal with must speak Arabic - Extensive experience with Telegram bot development. - Proven track record with creating bots for monitoring specific data metrics. - Strong background in website traffic data. Final product needs to successfully: - Integrate with external APIs to monitor and extract website traffic data. - Generate and send scheduled reports based on available data. - Advocate quick responses through notifications for any updates or changes in the website t...

I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards of efficiency and ac...

I'm looking for a skilled developer to set up an OCR system that can process invoices, receipts, and purchase orders. This system should be able to extract the vendor name, date, and total amount from these documents. More specific requirements can be discussed with my team. Key requirements: - Develop an OCR system to extract data from PDF, JPG, and PNG files. - Extract specific fields: vendor name, date, total amount. - Be open to further discussion and potential minor adjustments as briefed by my team. Ideal Skills: - Strong experience in Optical Character Recognition (OCR) technology. - Familiarity with financial documents and data extraction. - Excellent communication to understand and implement team's requirements.

...my monthly marketing campaigns. My small business, based in London, UK, caters to estate agents, necessitating the creation of a comprehensive lead database for email marketing purposes. Key Responsibilities: Set up and manage an Excel spreadsheet for the email database Regularly update the email database with new leads and modifications on a monthly basis Ensure the accuracy and integrity of data entries in the database Ideal Candidate: Proficiency in Excel and Microsoft Office suite Previous experience in email database management Meticulous attention to detail to uphold the accuracy of the database Proactive and capable of working independently to conduct monthly database maintenance This project has the potential for long-term engagement, with the possibility of additional...

I have 1 unfinished Access/VBA project. I need assistance to finish the project. The project require the developement of Access forms, VBA code and Generation of reports. My estimation is 3 working days. Max budget : 100$ Thanks for you bid

I'm seeking a proficient data scraper to extract both text and numeric data from a specified website for me. Key Responsibilities: - Scraping text and numeric data from a specified website. Desired Output: - The scraped data should be delivered in an Excel file format. Ideal Skills and Experience: - Proficient in web scraping, particularly for text and numeric data. - Familiarity with extracting data from websites. - Experience with delivering data in Excel format. Looking forward to receiving your proposals.

I'm in need of a proficient market researcher, ideally, with a solid background in the technology industry. I need comprehensive research focused on the business sector, aimed at understanding the market dynamics, opportunities and challenges within the industry. My ideal freelancer will have: - Expertise in market research - Understanding of the technology industry - Ability to extract and communicate valuable insights. Your findings will assist in our future business decisions.

1 Overview: This project de-identifies personal information in the video that detects a person o...an Edge Device connected to CCTV and protects personal information by changing the person's face or face + top and bottom. Here's what we need. 1.1 Edge Device must be sent video from the CCTV Stream. 1.2 A person must be detected in the input video. 1.3 The following information must be extracted from the detected person and made into a metadata (JSON) file. - Facial Embedding Information - Extract information about a person's attributes (hair length, hair color, top color, bottom color, top shape, bottom shape, shoe shape, color, etc.) 1.4 Change to a new face, a new outfit. 1.5 Real-time converted images and generated metadata should be delivered to the storage ...

...for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools wi...