Vba data extract vbaงาน

Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100

1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง

...proficient script writer to extract specific business data from an online directory, specifically Myagedcare.gov.au. This project will need a freelancer that possesses: • Significant knowledge and experience in data scraping technology • An understanding of the structure and functioning of online directories • Keen attention to detail The successful freelancer will carry out: 1. Extraction of business data: I require accurate extraction of contact details and business names from businesses listed on the directory. 2. Specific Directory Focus: The targeted directory for this exercise is Myagedcare.gov.au. The end goal is to create a clean and organized database of businesses in the aged care sector. Prior experience with online directori...

I'm in need of an expert who can efficiently extract text data from about 160 unstructured PDFs and enter it into a database. Key Responsibilities: - Extracting unstructured text data from PDF files - Accurately entering this data into a database Ideal Skills: - Proficiency in data entry - Experience handling unstructured data - Attention to detail The work will require a computer, a stable internet connection, and the ability to commit to accurate and efficient data entry. Experience with unstructured data is highly preferred.

I'm looking for a skilled professional to automate the task of entering data from specific Outlook emails into a structured format. The ideal candidate will have experience in: - Automating data entry tasks, and particularly from emails. - Working with Outlook's API or related tools. - Developing scripts or software to extract and categorize email content based on specific criteria. Key requirements include: - Extracting and processing data from emails based on criteria like sender's identity and keywords. - Ensuring the data is accurately transcribed and structured according to a predefined format. - Ensuring the process runs smoothly and efficiently, with the ability to handle a large volume of emails. - Providing a user-friendly soluti...

...scan the website/document for relevant data, and then interact with an AI model to retrieve information from the scanned website. The application will also include a chatbot feature that can be easily integrated into other websites as a microservice. Additionally, the application will support payment methods for premium features. Requirements: Website / Document Scanning Functionality: * Users should be able to input any website URL or document into the application. * The application should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data...

I need a professional web scraping expert to scrape information from medical service providers directories that are publically available from the providers' websites. Requirements: - Extract data including name, address, phone, and location from the directories - Ensure the information is accurate and up-to-date I'm looking for a freelancer who: - Has extensive experience in web scraping - Can deliver high-quality results quickly - Has excellent attention to detail The project is urgent so I require someone who can work on it immediately and complete it as soon as possible.

1 have 1500 company names and i want to find their related instagram accounts. Key Responsibilities: - Conduct market research on Instagram to extract relevant data Ideal Candidate: attentive to details Location: Dubai Data collection: google sheets

...looking for an expert who can integrate data from three platforms into my Laravel PHP ERP system. These platforms include Xero, and Sage accounting. Given these specific platforms, a freelancer with experience in working with them would be ideal. Additionally, PHP Laravel framework familiarity is essential. Requirements include: - Real-time synchronization: All data updated in any of these accounting software should reflect on my ERP system instantly. - Automatic data updates: An ability to schedule regular automated updates. - Custom Reporting: Tailored reports based on the data received from the platforms. - Error handling and Data Validation: Ensuring data is validated with robust error handling procedures. Given that I skipped indicating t...

...skilled professional who can help me scrape text data from e-commerce sites for data analysis. Key Requirements: - Data Scraping: The primary task is to extract text data from various e-commerce websites. This includes product descriptions, reviews, and any other relevant textual information. - Data Cleaning: Ensure the scraped data is accurate, clean and ready for analysis. - Data Analysis: This project is focused on data analysis, so experience in this area is a must. The ability to extract meaningful insights and trends from the scraped text data is crucial. Ideal Skills and Experience: - Proficiency in Web Scraping: A strong background in web scraping and working with text data is essential. - D...

...chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE Data Integration: Prior experience work...

I am in need of an experienced electronics technician with a thorough understanding and hands-on experience with scientific measurement equipment. Specifically, I require a professional who can: • Revamp the current configuration for improved compatibility. • Extract maximum functionality from existing resources. Key skills and experience: • Expertise in equipment modification. • Proficient in mechatronics (electronics, electrical and mechanical). Skills that are a plus: • Software programming. • Reverse engineering. • Pneumatics. • Drawing using CAD. We encourage under-grad students from UH, Rice, etc., to apply as an Intern. Requirements: • Must work at East End (near Second Ward) area in Houston. The project timeline is immediat...

I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.

I'm looking for a proficient Python developer to create a script that can ef...proficient Python developer to create a script that can efficiently scrape active IPs from a text file I will provide. The following specifics are required in this project: - The Skill-set: Strong Python programming skills, experience in IP scraping and working with text files would be an advantage. - Task Details: You need to extract the 'Activity Data' from these IPs. Profound knowledge in network protocols is a must-have. - Output Handling: The activity data extracted should directly be written to a text file. A clear understanding of FileIO operations in Python would be crucial. A successful completion of this project might lead to more future collaborations. I'...

I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .

Research Assistant for a Research Project Project Duration: [ 3 months] Overview: We are seeking a highly skilled and motivated Research Assistant to support a significant research project led by a University. The ideal candidate will possess a strong background in financial databases, data analysis, and academic research, with proven expertise in using Stata for data organization and analysis. Responsibilities: Download and extract data from financial databases and annual reports as well as others as required. Efficiently merge and manage datasets from multiple sources to ensure consistency and accuracy. Conduct thorough literature reviews in finance and related fields to support research objectives. Utilize Stata to analyze complex datasets, perform econom...

I'm looking for an experienced data scraper who can extract text data from marketing websites for subsequent data analysis.

I need a professional to scrape specific details from a ...scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in dat...

I'm looking to create a 5-minute video presentation for my personal project. I already have some initial parts of the video, which I will provide, and I'd like you to extract the contents from a very detailed website and mockup graphics. Key Requirements: - The video should follow a specific style of presentation (details will be provided). - The final video should be around 5 minutes long. - Some parts of the video are already completed and will be shared with you to integrate with the new materials. Target Audience: I will share detailed information about the target audience via messages. Ideal Freelancer: - Experience in creating engaging presentations - Proficiency in video editing and animation - Ability to work with mockup graphics

I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

...company information from platforms like LinkedIn, focusing on contact details for sales lead generation. Key Details: Target Data: Company Information on LinkedIn Purpose: Sales Lead Generation Responsibilities: Utilize advanced web scraping tools and niche database search techniques to extract company information, emphasizing contact details. Ensure accuracy and reliability in gathering and organizing contact information from various sources. Collaborate on developing targeted outreach strategies based on collected data. Ideal Skills: Proficiency in advanced web scraping techniques, particularly on LinkedIn and other niche databases. Ability to navigate and extract data from specialized platforms beyond Google and mainstream databases. Understandi...

I'm looking for a skilled Python programmer to assist in creating a metrics system for my data analysis project. Below are the key aspects of the project: - Data Type: The project will primarily involve the processing and analysis of text data. Prior experience with this data type is a definite advantage. - Goal: The main objective of this project is to perform in-depth data analysis. I need the freelancer to assist in developing metrics and calculations for the data. - Deliverables: The final output should be presented in a report format. Ideal skills for this project would include expertise in Python, data analysis, experience with text data, and the ability to create comprehensive reports. I want to write a python code f...

I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this ...

...multi-page PDF files and image files provided by our clients and extracts that data into CSV files. Due to format differences, existing AZURE OCR API have not met our requirements, necessitating a custom solution. ✔Specific Requirements: 1. Ability to read QR codes from multi-page PDF files, multiple PDF files, and image files such as JPGs and PNGs. 2. Capability to analyze the data within the QR codes and format it into CSV files. 3. Development must be done in either Python or JavaScript. ✔Skills Required: -Experience in development with Python or JavaScript. -Knowledge of OCR technologies and QR code reading techniques. -Experience in handling PDF and image processing. ✔Project Goals: The goal is to efficiently extract data from various files provided b...

I am in need of an expert in data extraction from a medium complexity website that involves some dynamic content. The project mainly consists of extracting textual data. Your proficiency in working with dynamic as well as static web pages will be key. Tasks involved include: - Navigate through Javascript mixed contents - Scrutinize and extract required textual data - Verify the accuracy of extracted data Look forward to an expert with the following skills: - Experience in both static and dynamic website data extraction - Detail-oriented for accurate data extraction - Knowledge of Javascript to manoeuver through the website content

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

I'm seeking a professional who can extract both mobile telephone numbers and full email addresses from potential leads in specified European countries. The primary purpose of this data collection is for marketing and sales. Key Aspects: - Target Countries: Ireland, Malta, Denmark, Iceland, Belgium, Portugal, Luxembourg, and Monaco - Data Requirements: Less than 100 leads from each of these countries - Contact Details: High-quality and accurate mobile numbers and full email addresses - Purpose: Marketing and sales activities Ideal Skills and Experience: - Proficient in data extraction and lead generation - Strong knowledge of European markets and consumer behavior - Experience in extracting mobile telephone numbers and email addresses - Previous success in...

My project requires the assistance of an experienced data analyst or data miner. I'm working on a market research project, which requires the extraction of text data from a specified website. Here are the specific details: - Task: Extracting text data from a website for data analysis - Output: All extracted text data should be provided in a CSV file Given the nature of this project, prior experience in web scraping, data extraction, or data mining is highly desirable. The ability to accurately extract data and transfer it into a CSV file is essential.

...already been modelled fine but I believe that it is missing a wrap layer (cage mesh & reference mesh) because when I try to attach it in-game, it looks like it is not rigged correctly and doesn’t follow the hand of the avatar. I can send you a UGC zip that includes the OBJ file etc, but most importantly I can send you a Roblox world that has both the avatars and the watch on hand, so you can also extract them from there. The model is intended to be uploaded as a gift for people who complete certain tasks in my own world (need final fbx format with mesh etc) Please, only people with proven experience on Roblox accessories. Will ask to verify and walk me through the process. If you're adept at 3D rigging and familiar with the Roblox platform, I look forward to se...

...someone who can fix an error in a custom plugin for me. ? Requirements: Need an experienced WordPress developer for making adjustments to an existing data scraping plugin. The task to perform is to skip/skip cloudflare so that the plugin can extract the data without problem I explain: I have a custom plugin in WordPress, which extracts information all right, it turns out that the website activates Cloudflare on its side and that is preventing the plugin from being able to extract the information correctly. What I need: I'm looking for someone who can modify the plugin or do what is necessary so that it skips or bypasses Cloudflare and can extract the information without problem. ? Budget: $10 - $50 - I need it no later than Monday. For an e...

I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you ...

...Python expert who can meticulously extract text and tables from PDFs for data analysis. The requirements are as follows: - Develop a Python solution in form of a Jupyter Notebook - Preferable use of the libraries PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber for extraction Required Skills and Experience: - Proficient in Python - Familiarity with Jupyter Notebook - Experience with PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber - Data extraction and analysis expertise. Your commitments would include understanding the architecture of the PDFs, and the most effective library for extraction in each case. The ultimate goal is to create a Python script that eases the data extraction process for subsequent analysis. Whoever can most efficiently extr...

...experience in API integration and data handling to assist me with incorporating meter reading systems Tehama, Cereniti, and Inovonics into our existing system. This integration is referred to as MDM, or meter data module, with our software provider Utility Trackr. Key Project Requirements: - Extracting specific data: The project requires the extraction of meter readings, property information, and other necessary data from the aforementioned meter reading systems. Specifically, I need to extract Meter ID, Unit ID, and Date of read, Current Read. Dual transmitters require a unique ID. - Generating CSV or Text files: The extracted data should be organized and formatted into CSV or TXT files. Each property in the system should have its own file co...

...I’ve been training for at my place of work for the past 4/5 months now and if my hours are reduced it will impact my means of living dramatically) This project requires: - A deep understanding of the legal system and the specific requirements for a special hardship license application. - Exceptional writing skills, particularly in a legal context. - Strong communication skills, as you'll need to extract the right information from me to build a strong case. - Empathy and a sensitive approach, as this is a challenging and potentially life-changing situation for me. Please only bid if you have the right experience and skills to deliver a high-quality, detailed, and compelling affidavit/application for this specific legal purpose....

I'm in need of a proficient data scraper to pull a list of specific job titles for my list of Property management companies. I already have the Company name, state, street address, and zip code for these firms, but now I need someone to mine the contacts within them. I would like to start with 150 companies but I will need thousands very soon. This will be an ongoing relationship. Specifics include, but are not limited to: - Facility Managers - Construction Managers - Building Managers - Maintenance Managers You should have experience in data mining and web scraping, showcasing a solid understanding of how to extract specific information from given sources. A background in extracting information specifically for real estate industry firms would be a significant...

I need to label 20,000 pictures for data analysis purposes. - The main purpose is to extract text from these images. - YOU SHOULD NOT USE OCR, NOR ANY OTHER SOFTWARE, IT SHOULD BE MANUALLY DONE. - It should be 100% accuracy by manually entering the data -Each image contains a maximum of 5 characters Examples have been attached

...looking for an expert who can integrate data from three platforms into my Laravel PHP ERP system. These platforms include Xero, and Sage accounting. Given these specific platforms, a freelancer with experience in working with them would be ideal. Additionally, PHP Laravel framework familiarity is essential. Requirements include: - Real-time synchronization: All data updated in any of these accounting software should reflect on my ERP system instantly. - Automatic data updates: An ability to schedule regular automated updates. - Custom Reporting: Tailored reports based on the data received from the platforms. - Error handling and Data Validation: Ensuring data is validated with robust error handling procedures. Given that I skipped indicating t...

I'm seeking an experienced developer to create a web application. The purpose of this application is to extract table data from PDF documents and translate it into various chart formats, specifically bar graphs, pie charts, and line diagrams. I also need the application to be capable of handling data pivoting. Ideal candidates would have strong skills in data extraction techniques, chart creation, and web application development. Understanding of data manipulation and presentation is also a must.

...for building a Gmail email scraper/notifier. The ideal candidate should have a strong understanding of data scraping and email handling. The aim of the project is to: - Extract and display specific emails from Gmail in a user-friendly card format within an application grid. - The information to display on each card will include part of email body, phone numbers and web links. The phone numbers should be displayed in a clickable link format so that they seamlessly work with a soft phone application like RingCentral without need to use their API. Emails containing web link will have the option to automatically open the link in new tab in default browser. Skills required: - Proficiency in data scraping - Experience with Gmail API - Excellent knowledge in Python or a...

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.

I'm looking for a skilled video editor to create a 30-second short reel showcasing the works of a Greek ad agency. Key Project Details: - You'll need to extract content directly from their active Facebook and Instagram accounts. - The purpose of this reel is to showcase the agency's works, so a strong sense of visual storytelling and marketing is crucial. - The deadline for this project is 1 day. Skills Needed: - Strong experience with video editing and animation, ideally including experience in social media content creation - Ability to meet tight deadlines while maintaining quality - Understanding of marketing and visual storytelling - Familiarity with the use of social media platforms for business promotion Budget for this project is 10 euros, so please only bi...

...prospective clients. So I need to automate a regularly occuring search for the most recent lawsuits that are filed on these clerks' websites and extract the defendants' names, mailing addresses and case numbers. The only problem is that the addresses are not found neatly on the web pages of the search results, but they must be extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an excel file for mail merge and printing ...

I need a collection of flat icons related to food ingredients. you can use any website or any source download the icon rename the file as per my name in my list, and make sure the size is 64 x 64 PNG compressed some example of items in my list "salt black pepper olive oil garlic butter sugar allpurpose...use any website or any source download the icon rename the file as per my name in my list, and make sure the size is 64 x 64 PNG compressed some example of items in my list "salt black pepper olive oil garlic butter sugar allpurpose flour onion water oil milk white sugar eggs coriander lemon juice onions unsalted butter green chillies cinnamon pepper chilli powder kosher salt tomatoes vanilla extract turmeric powder vege oil ginger cumin seeds parsley baking powder egg...

I have a digital PDF document that needs to be conv...converted into plain text - I'm looking to edit the content rather than preserve the formatting. I also need the content to be transferred into an Excel spreadsheet for further analysis and use. Key Requirements: - Extract text content from a digital PDF document. - Transfer extracted content into a structured Excel spreadsheet. - Ensure the formatting of the content is conducive for further editing and data analysis. Ideal Skills/Experience: - Proficient in PDF conversion tools and techniques. - Strong data entry skills, with a keen eye for detail. - Knowledge of Excel and experience in data structuring. - Ability to maintain the integrity of the textual content during conversion. - Familiarity with c...

... You will be paid by the hour. I will review your work rate. If I feel it is low or the work is not being performed efficiently I will pay for your time and cancel the job. I intend to check the work each day. Sample spreadsheet Here is a link to a sample of the spreadsheet - This is an extract from the larger main sheet. The actual version has around 450 rows to complete. Workflow Here’s how the process works. This applies to each row of the spreadsheet. 1) You do the research and complete the URL field and mark it as ‘ready for review’. If a link cannot be found mark it as such. 2) I will review it 3) If ok, I’ll mark as approved OR reject with a comment. If the latter, you

I need a freelancer to convert some PDFs into Word files. I'm looking specifically to extract text from these PDFs while keeping their original formatting as much as possible. The PDFs contain images with text, so I also need the freelancer to perform Optical Character Recognition (OCR) to extract text from the images as well. Ideal Skills: - Proficiency in Adobe Acrobat Pro or similar software for PDF manipulation - Experience with Optical Character Recognition (OCR) software - Familiarity with the nuances of document formatting - Attention to detail to ensure accurate and complete text extraction

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 ? my preference is for a free AI, a free API and with the possibility of sending it a PDF file

I require a professional with good attention to detail to extract specific information from the HealthPoint directory. The data will be for a key area in Auckland, New Zealand. The key details wanted are: - Doctor's name - Doctor's email - Clinic/GP practice - Clinic address - Contact number - Generic surgery or PA email address This data will be used for direct communication with doctors to communicate news about their local hospital. Having experience in data scraping is a must; we will provide the spreadsheet to input the data into in order for us to upload it to our CRM.