Extract worksheet name vba macro jobs

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, s...should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot tables. - Macros: The project involves basic macro creation and execution. - Conditional Formatting: You should be able to apply conditional formatting to present data in a more user-friendly manner. If you believe you have the right skill set for this project, pleas...

I'm in need of a professional who can help me extract specific data on the results of the Tokyo 2021 Paralympic Games from the official website - The data I require includes: - Athlete profiles - All the results of each competitor - Medal winners The extracted data should be presented in a CSV file format. It should be in a similar format as this dataset on the results of the Olympic games: No specific analysis is needed on the extracted data. Ideal skills and experience for this job include: - Proficiency in web scraping - Experience in data extraction - Expertise in data formatting and CSV files Your professional approach and ability to deliver accurate, complete

...build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, ma...

I am seeking an experienced developer to create a website scraper which is capable of collecting various pieces of data. This savvy tool must be designed to extract from () site: - Text content - Images - Product information - Address - Contact details - Videos It is essential for the scraper to perform its task on a daily basis. Yet, there won't be a need for the gathered data to be automatically integrated into a database. Ideal Skills: - Web scraping - Developing scraping bots - Programming knowledge - Manual data mining expertise Please only apply for this job if you have significant experience in creating web scrapers. This project requires a quick turnaround, so the ability to work under time constraints is key. Let's converse about specifications, and develop t...

...within a dataset that includes between 6-10 variables. Key Project Requirements: - Utilize panel data: Experience in handling panel data is a must for this project. The ability to understand the nuances of this data type will be crucial for accurate analysis. - Regression Analysis: In-depth knowledge of regression analysis is required, especially in the context of panel data. The ability to extract meaningful insights and estimate the impact of one variable on another is the core task. - Data Interpretation: The successful freelancer will be able to provide clear, concise interpretations of the analysis results. The ability to communicate complex data findings in an understandable manner is highly valued. Ideal Skills and Experience: - Proven track record in regression analysi...

I am seeking a proficient data scientist to help me extract and analyze information within the Bangladesh construction industry. This project focuses on market trends, industry analysis, and project specific statistics. This project's primary intent includes: - Uncovering market opportunities - Competitive analysis within the construction sector The findings will be utilized for: - The development of robust marketing strategies - Making data-driven business decisions Ideal candidates should have prior experience in data mining within the construction industry and have a solid understanding of market analysis and project statistics. Previous work within the Bangladesh market would be advantageous.

We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, C...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

...supports efficient data aggregation and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing analytics requirements. - Efficient Data Export and ETL Processes: Set up and manage the rapid export of data from various platforms using APIs. Develop and implement ETL (Extract, Transform, Load) processes to clean, transform, and load data into the database swiftly. - Documentation: Produce concise and clear documentation on the data architecture, ER diagrams, and ETL processes to support ongoing maintenance and scalability. - Collaborative and Rapid Execution: Work closely with the project manager and other team members to ensure alignment of the databas...

I need a web scraper to extract specific data from various websites. The project will involve: - Identifying the necessary data to be scraped - Building a scraper to extract this data Ideal skills for this job include: - Proficiency in web scraping tools - Familiarity with web data extraction techniques - Ability to work with and extract data from various websites Please provide your quote for this project.

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for a skilled web scraper who can extract detailed information regarding the sellers on the Miravia website. Requirements: - Extracting Seller Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention

...format. Milestones: MS1: provide python OOP module to measure the blurness & sharpness quantification of images and videos data will be written in same filename but with .json as extension we will share you testing images and videos 2 modes required - demo mode with showing the video+persisting the demo video - performance mode, which only processes the data MS2 same as MS1, except now you extract the different noises from the image. Also as json MS3 now detect faces and identify the noises and sharpness/bluryness of the faces. Also as json MS4: rest will be discusses and agreed mutually Budget? will not be disclosed, place your best bid to get considered Payment? - you estimate in a WBS (optimistic, expected, pessimistic, where optimistic < expected < pessi...

...accounting software like quickbooks. Ideal Skills: - Proficiency in SaaS tool development using a no code tool flutterflow - Experience with real-time data processing - Previous work on financial reporting tools - Familiarity with integrating systems with accounting software User journey - Register with Google account - link with accounting platform like Quickbooks (1 click integration) - Extract data and save the data in AWS securely - Do some calculations on the data (we will provide it) - Display the information in widget formats in the platform - Client pays for premium features and payment is via stripe - Notification and Reports are emailed The selected freelancer should be able to develop a user-friendly, intuitive and accurate tool that will help small business o...

I'm in need of a freelancer who can work with OpenStreetMap data to extract specific elements and format them into a .csv file. Key Requirements: - Extracting Geographical locations: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber, Latitude, Longitude. If available the Community and the Code of the Community The dumpfile is on: The Download and Format-Process should be automated and if possible triggered with a download Button on an HTML Page. By clicking on the Download button, the process of formating the OSM into .csv is startet. Coding of .csv should be UTF-8 Ideal Skills: - Proficiency with OpenStreetMap data and extraction tools. - Experience in formatting data into .csv files. This

I am looking for a professional who has experience in data scraping to extract email addresses of senior level employees in the Building Industry, specifically from the United Kingdom. This task involves collecting the email addresses of 100 senior level employees. Key Requirements: - I need the first name, job title, and email address of each employee. - All the email addresses should be from the United Kingdom. The ideal freelancer for this project should have: - Experience in data scrapping and data mining. - Proficiency in tools and techniques for extracting data from web sources. - Attention to detail to ensure the accuracy of the collected information. - Familiarity with the Building Industry and the job titles associated with senior level roles in this field.

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I am looking for a creative and professional design for the business name: Sculpt and Glow. The colours can include white, black, dark green, peach and/or gold. I have no preference to font or size. I would like the name to present sophisticated, clear and classy. I am open to any creative suggestions and would appreciate a few options to choose from. Thank you!

I'm looking for a skilled developer who can create a personalized Roblox script hub for the games Pet Simulator 99, Jailbreak, and The Survival Game. Key Requirements: - Decompilation: You'll be required to decompile the mentioned Roblox games and extract essential elements for the script hub. - Auto Farm Feature: Implement an auto farm feature within the script hub that works seamlessly across all the games. - Personalized Design: Design the script hub with a minimalist theme, ensuring it's visually appealing and user-friendly. User Interaction: - The script hub should offer a graphical user interface (GUI) for users to easily navigate and interact with. Ideal Skills and Experience: - Proficient in Roblox scripting and decompilation. - Experience in developing che...

I am looking for assistance in creating a visually engaging, professional PowerPoint presentation, using a provided style template, based on a 64 double side page Word document. Key details: - Extract key points and messages to form a summarized version of the Word document's content. - Encompass a range of 50 to 80 slides with a balance between text and relevant images to ensure readability and viewer engagement. - Align with pre-existing PowerPoint template aesthetic. Ideal candidate should have: - Excellent summarization skills and attention to detail. - Proficiency in PowerPoint. - Experience in creating engaging corporate presentations. Presentation would need to be done in 5 days

The machine learning component of this hybrid profile creation system in a Flutter app involves integrating a TensorFlow Lite model, possibly using DistilBERT for its efficiency and effectiveness in natural language processing tasks. The model's role is twofold: Text Analysis and Categorization: It processes user-generated text inputs and web-scraped content to extract meaningful insights, such as sentiment, key phrases, or categorization of interests. This helps in dynamically adjusting the user's profile to reflect their preferences and behaviors accurately. Usage Pattern Learning: The system tracks and analyzes app usage statistics to learn about user preferences over time. Machine learning algorithms can identify patterns in what features or content the user interacts...

Please Sign Up or Login to see details.

I'm in need of a skilled data miner who can help to extract certain details from a vast range of Shopify products. Your mission, if you choose to accept it, is as follows: - list products that contain non-English writing or words in text and videos - Organise and sort these findings for simple review - Identify and list any products filled with non-English language in the description, pictures or images - Compile lists of products that aren’t currently making top-seller lists - List any products can not be delivered in eight days or less. Please note that tractors and food vans may take up to two months to deliver. - List any products that are not suitable for industrial purposes/non-commercial products. Ensure that the products you are considering are meant for commerci...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

I require an efficient solution to extract contact details, specifically phone numbers and email addresses, for newly sold residential properties.

...Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge ...

More details: What format are the company names provided in? pdf Do you have the capability to extract text from the PDF files? Not sure How soon do you need your project completed? ASAP

...Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category (optional - ...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm in need of a developer who can create a n8n script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium&qu...

Need a logo for a civil concrete road company Company Name : MHF Civil

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I need a professional to mine data for me. I need you to download and extract the submissions and comments from a public Reddit dataset for 40 subreddits that I will give you. - Data Collection: Please extract the submissions and comments from this academictorrents link: https://academictorrents.com/details/56aa49f9653ba545f48df2e33679f014d2829c10/tech&filelist=1 I only want the comments and submissions for specific subreddits that I will supply to you. Please save the extracted data as csv file. - Frequency: This is a one-time job. Skills and Experience: - Torrent download and extraction.

I am seeking to have a tool developed that can accurately scrape specific data from Airbnb and AirDna. The aim is to retrieve information about rental prices, occupancy rates, and property descriptions, etc. Key Features: - Efficient data scraping: The tool should successfully extract rental prices, occupancy rates, and property descriptions from Airbnb and AirDna. - Localized scraping: The data scraping should be focused on a specific city, which will be revealed once the project commences. Use of Data: The scraped information will be primarily used for market analysis purposes. The data will be instrumental in helping me understand the dynamics of the rental market within the specific city. Skills & Experience Required: - Proven experience in data scraping, especially from ...

We are in search of a skilled freelancer proficient in web scraping with Scrapy to extract product data from This project involves scraping the Category page to retrieve product details including name, price, SKU, URL, breadcrumb, currency, and brand. Targeted webpage: Category page of Required data: Product name, price, SKU, URL, breadcrumb, currency, and brand Experience: Prior experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all categories

...tracking visitor data, and can help me in capturing contact information of potential customers who do not complete any forms on the site. Key Requirements: - Advanced Visitor Data Collection: The system should be able to capture details like device type, referral source, behavior patterns, and time on page for all visitors. - Contact Information Extraction: The primary goal is to extract the contact details (Name, Address, Phone, and Email) of the visitors who do not submit any form on the site. Ideal Skills and Experience: - Proficiency in Third-Party Tracking Services: The selected freelancer should be well-versed with various third-party tracking services and should be able to recommend and integrate the most suitable one for my website. - Expertise in Visitor Data ...

Hi Sir, I can create the macro as per instruction shared . Thanks Arun

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

...format. Milestones: MS1: provide python OOP module to measure the blurness & sharpness quantification of images and videos data will be written in same filename but with .json as extension we will share you testing images and videos 2 modes required - demo mode with showing the video+persisting the demo video - performance mode, which only processes the data MS2 same as MS1, except now you extract the different noises from the image. Also as json MS3 now detect faces and identify the noises and sharpness/bluryness of the faces. Also as json MS4: rest will be discusses and agreed mutually Budget? will not be disclosed, place your best bid to get considered Payment? - you estimate in a WBS (optimistic, expected, pessimistic, where optimistic < expected < pessi...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm in need of a skilled Korean calligraphy artist (who is Korean itself and knows spoken Korean) to create custom name pieces for me in your unique style. Key Project Details: - I'm looking for someone experienced in Korean calligraphy to craft names in Korean in your own calligraphy style. The style can be Traditional calligraphy, Modern calligraphy, Brush lettering, or a fusion of your own. - The names can be either in Formal (Hanja), Semi-formal (Hangul), or Casual (Stylized Hangul). You are free to choose the style that you feel best suits the names. Application Requirements: - Please include examples of your past work specifically in Korean calligraphy. I'd like to see a range of styles to gauge your versatility. This project is a great opportunity for you ...

For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence further actions.

Please Sign Up or Login to see details.

...you give me the code. So branch one will have different tabs frequency than the other branch. The UI should reflect that. 3. Maybe it would be easier if it records the exact keystrokes I make and then plays them back(no Mouse) a. So I can just do my routine over and over and then a macro records that specific pattern and plays it back by pressing an assigned hotkey. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and igno...

I'm looking for a proficient practitioner in Tensorflow and machine learning to help develop a solution based on image and video data. Here's what I need: - Design and train a machine learning model that can extract meaningful information from our data. - The model should be capable of scene recognition in video and images. Your solution needs to reliably and accurately identify and classify different scenes. - You should be comfortable working with Tensorflow and have a solid understanding of its capabilities and limitations. Ideal skills and experience: Tensorflow proficiency, solid training in machine learning, experience in working with image and video data, and expertise in scene recognition algorithms. Your proposal should detail your plan of action and track r...

Project Description: I am looking for a skilled Data Analyst to help develop a system for classifying email messages as SPAM or HAM. This involves downloading data from a public source, processing it to extract and compute various features, and analyzing these to determine patterns indicative of SPAM. Responsibilities: Download email data from a specified public archive. Create R functions to extract and calculate over 20 variables from each email, such as the number of recipients, percentage of capitals, and URL presence. Analyze this data to explore variable relationships and determine SPAM/HAM status. Generate visual representations of the data and analysis findings. Provide a detailed report on the methodologies used, results obtained, and insights gained. Required Skill...

...metadata from the images, not manually added. - **Output Format:** I need the final points to be saved in KML format, for easy integration into Google Earth. - **Quality Assurance:** Accuracy is key, the points should correctly represent the image positions. They will be broken into 3 colours depending on the date they were taken, the data is in the folder name and file name. Ideal Skills: - **GPS Data Handling:** Understanding of how to extract and work with GPS metadata from images. - **Google Earth Proficiency:** Experience in creating KML files and working with Google Earth is a must. - **Automation:** Familiarity with tools or methods that can automate the process of generating points from image metadata would be a significant advantage. If you have ...

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

As a business, I'm looking for a skilled freelancer to help me create an extractor for past paper content from multiple different exam boards/papers from different subjects. This will be from PDF files and organize it into a JSON format. This will help in creating a structured database for our educational materials. Key Requirements: - Extract data from PDF files: The freelancer should have experience in data extraction from PDFs. The goal is to extract content like questions, answers, and any other relevant details. This extractor should be able to be used for different exam boards - Organize data by year, subject, and difficulty level: The extracted data should be categorized based on these parameters. This is crucial for our business as it will help us create a user-...

Please Sign Up or Login to see details.